Re: Change master to standby

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Alexander Perepelica <alexondi(at)rambler(dot)ru>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Change master to standby
Date: 2011-08-17 11:24:18
Message-ID: CAHGQGwG_sFsFF6Hyp9SqAcB6Nu=GE1b3dHC2H17u1cNsBJ0HZQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 16, 2011 at 6:55 PM, Alexander Perepelica
<alexondi(at)rambler(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message alexondi 2011-08-17 11:41:23 Re: Change master to standby
Previous Message Rebecca Clarke 2011-08-17 11:02:30 Connection Error during Pg_restore