Postgres Pro
Downloads
Home   >   mailing lists

Re: Change master to standby - Mailing list pgsql-general

From Fujii Masao
Subject Re: Change master to standby
Date
Msg-id CAHGQGwG_sFsFF6Hyp9SqAcB6Nu=GE1b3dHC2H17u1cNsBJ0HZQ@mail.gmail.com
Whole thread Raw
In response to Change master to standby  (Alexander Perepelica <alexondi@rambler.ru>)
Responses Re: Change master to standby  (alexondi <alexondi@rambler.ru>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Rebecca Clarke
Date:
Subject: Connection Error during Pg_restore
Next
From: alexondi
Date:
Subject: Re: Change master to standby