Looking for some help with HA / Log Log-Shipping

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 <l_faillie@yahoo.com> a écrit :

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/                   
What I did is :
* created the master db* create replication role* updated postgresql.conf* finally replicate everything on the salve node using pg_basebackup (with -R option)

But now I'm lost with §26.2.4 Setting up a standby server.
In which file I have to put the primary_conninfo and other options ?
Thanks
Laurent
ps: my goal is to install the PAF

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 node.

However, as directed by the official documentation you've mentioned,
section 26.2 https://www.postgresql.org/docs/12/warm-standby.html
<https://www.postgresql.org/docs/12/warm-standby.html&gt; really advises that
we set-up log-shipping to better support the stand-by recovery process, and
make sure we can easily recover from any transient failure.
I'm a very happy user of wal-g for this; I'm currently running 4 different
Postgresql clusters some pg10 ando some pg12, but wal-g is great for any of
them; I'm running them in Kubernetes, so I'm configuring wal-g directly via
the Environment of the Postgresql containers, making sure wal-g is
installed in my custom Postgresql image, of course. Then it is configured
just like this:

archive_mode = always

archive_command = 'wal-g wal-push %p'

archive_timeout = 60

restore_command = 'wal-g wal-fetch %f %p'

Adalberto

Il giorno mer 31 mar 2021 alle ore 17:39 Laurent FAILLIE <
l_faillie@yahoo.com> ha scritto: