Home > mailing lists

Looking for some help with HA / Log Log-Shipping - Mailing list pgsql-general

From	Laurent FAILLIE
Subject	Looking for some help with HA / Log Log-Shipping
Date	March 31, 2021 13:27:08
Msg-id	559493559.2452115.1617186428338@mail.yahoo.com Whole thread Raw
Responses	Re: Looking for some help with HA / Log Log-Shipping
List	pgsql-general

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 :

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

From: Mohan Radhakrishnan
Date: 31 March 2021, 11:36:06
Subject: Primary keys and composite unique keys(basic question)

From: david.turon@linuxbox.cz
Date: 31 March 2021, 15:53:10
Subject: JSON operator feature request