Re: Looking for some help with HA / Log Log-Shipping

2021-04-01 Thread Adalberto Caccia
Hi, Postgresql 11 already changed the position of replication parameters, now all hosted in the main postgresql.conf file. So on the standby node, instead of a recovery.conf file, just an empty STANDBY.SIGNAL file is needed in the $PGDATA directory to start Postgresql as a standby replica on that n

Re: Looking for some help with HA / Log Log-Shipping

2021-03-31 Thread Laurent FAILLIE
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 trying

Looking for some help with HA / Log Log-Shipping

2021-03-31 Thread Laurent FAILLIE
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/