Hello,
Which distribution are you speaking about ?
I'm using Gentoo and postgresql is versioned : you install the versions you're
looking for and switch form one to another using eselect
laurent@torchwood ~ $ eselect postgresql list
Available PostgreSQL Slots
11 11.7
12
Replying to myself :)
It seems pg_basebackup did all the tricks, even restarting the slave. And it is
in standby mode.Do I have anything to do in addition ?
Thanks
Le mercredi 31 mars 2021 à 12:51:29 UTC+2, Laurent FAILLIE
a écrit :
Hello,
We are running Postgresql 12 and I'm t
Hello,
We are running Postgresql 12 and I'm trying to put in place streaming wal
replication.
I followed officiale documentation (
https://www.postgresql.org/docs/12/warm-standby.html ) as well as this tutorial
:
https://scalegrid.io/blog/managing-high-availability-in-postgresql-part-1/
Hello all,
thanks all for your replies : I started to learn Patroni.Anyway, any
alternative with my customer want's also LoadBalancing ?
Thanks
Laurent
Le jeudi 9 juillet 2020 à 17:47:23 UTC+2, Laurent FAILLIE
a écrit :
Mainly for HA and DR but it can help also for the future
Mainly for HA and DR but it can help also for the future if a load balancing is
possible. But it's not mandatory yet.
Thanks
Le jeudi 9 juillet 2020 à 17:30:35 UTC+2, Ron a
écrit :
For high availability, for load sharing or for disaster recovery?
On 7/9/20 8:53 AM, Laurent FA
Hello,
I've been asked by one of my customer to know which are the possible clustering
solution for PostgreSQL ?
Active/passive ?Active/active ?
if possible free or not too expensive.
Thanks
Laurent
Hello,
I'm trying to save a database from a dying disk on a Gentoo/Linux box.
Unfortunately, when I'm issuing a
$ pg_dumpall --clean
I got
pg_dump: [programme d'archivage (db)] échec de la requête : ERROR: array size
exceeds the maximum allowed (268435455)
pg_dump: [programme d'archivage (db)]