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

Поиск

Список

Период

Сортировка

От	Laurent FAILLIE
Тема	Re: Looking for some help with HA / Log Log-Shipping
Дата	31 марта 2021 г. 18:38:58
Msg-id	166716532.2578826.1617205138799@mail.yahoo.com обсуждение исходный текст
Ответ на	Looking for some help with HA / Log Log-Shipping (Laurent FAILLIE <l_faillie@yahoo.com>)
Ответы	Re: Looking for some help with HA / Log Log-Shipping
Список	pgsql-general

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 :

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

В списке pgsql-general по дате отправления:

От: Mohan Radhakrishnan
Дата: 31 марта 2021 г., 18:18:15
Сообщение: Re: Primary keys and composite unique keys(basic question)

От: Radoslav Nedyalkov
Дата: 31 марта 2021 г., 18:51:48
Сообщение: standby fails with out-of-order XID insertion