Thread: Change master to standby

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

Thank you for the answer!

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Change-master-to-standby-tp4703925p4707810.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.