Change master to standby
Started by alexondiover 14 years ago3 messagesgeneral
Re: 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
Re: Change master to standby
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.