Re: Change master to standby

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: Change master to standby
Дата
Msg-id CAHGQGwG_sFsFF6Hyp9SqAcB6Nu=GE1b3dHC2H17u1cNsBJ0HZQ@mail.gmail.com
обсуждение исходный текст
Ответ на Change master to standby  (Alexander Perepelica <alexondi@rambler.ru>)
Ответы Re: Change master to standby
Список pgsql-general
On Tue, Aug 16, 2011 at 6:55 PM, Alexander Perepelica
<alexondi@rambler.ru> wrote:
> Can I change server mode master to slave (standby) without restarting?

Which replication tool do you use? If streaming replication, the answer is "No".
You need to shutdown the master, make a fresh base backup from new master,
create recovery.conf and start the server as the standby from the backup.

I have no idea about other replication method.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

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

Предыдущее
От: Rebecca Clarke
Дата:
Сообщение: Connection Error during Pg_restore
Следующее
От: alexondi
Дата:
Сообщение: Re: Change master to standby