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

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> 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(at)yahoo(dot)com> ha scritto:

> 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(at)yahoo(dot)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
>