Re: Streaming replication, master recycling

Поиск
Список
Период
Сортировка
От Venkata Balaji N
Тема Re: Streaming replication, master recycling
Дата
Msg-id CAEyp7J-hgiQgjhE2wSKyWJy21joXQyePgEAHPsWnd5Jvz0hu7g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Streaming replication, master recycling  (<fredrik@huitfeldt.com>)
Ответы Re: Streaming replication, master recycling  (Venkata Balaji N <nag1010@gmail.com>)
Список pgsql-general

On Wed, May 11, 2016 at 9:04 PM, <fredrik@huitfeldt.com> wrote:
I apologise for the missing data. 

we are running 9.1.15 on debian servers.

There is a possibility of making the old master standby if you have promoted standby after clean-shutting down the master. I I tested this in 9.2.x and later versions. This is a manual process in 9.2, i think it is the same in 9.1.x version as well. 

The process is -

- Ensure master and standby are in sync before switching over
- Promote standby
- build recovery.conf at old master with the parameter recovery_target_timeline set to 'latest'
- When you start the old master, it will ask for timeline history files which you need to manually transfer from new master
- The old master must become standby

Hope this helps and works in 9.1.x

Regards,
Venkata B N

Fujitsu Australia


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

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Using both ident and password in pg_hba.conf
Следующее
От: Alex Magnum
Дата:
Сообщение: Keeping top N records of a group