Postgres Pro
Downloads
Home   >   mailing lists

Re: failover and switchover in postgresql - Mailing list pgsql-admin

From Payal Singh
Subject Re: failover and switchover in postgresql
Date
Msg-id CANUg7LBkdjDX+3FSRyiX+5tB0S343ObtRTtrb2HahogcgtrVMQ@mail.gmail.com
Whole thread Raw
In response to failover and switchover in postgresql  (metsarin <metsarin@yahoo.com>)
List pgsql-admin
Tree view
After performing a failover, the old slave becomes the new master, but the opposite is not true, that is, the old master does not automatically become the slave. You will need to set up replication from the new master to the to-be slave to be able to switch back. 

Payal Singh,
OmniTi Computer Consulting Inc.
Junior Database Architect,
Phone: 240.646.0770 x 253


On Fri, Oct 25, 2013 at 4:48 AM, metsarin <metsarin@yahoo.com> wrote:
Dear Community!

For example, I have two servers. First is the primary server and second is
the slave server. I need slave server  to become primary (temp) during
primary server is down. Then old primary was fixed. I need old primary
server is the primary server and then old slave server (new primary (temp))
to become slave server. Pls help me to explain how solve this problem.
Thanks!



--
View this message in context: http://postgresql.1045698.n5.nabble.com/failover-and-switchover-in-postgresql-tp5775885.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: "Steven Hartland"
Date:
Subject: Re: ZFS-FreeBSD + postgresql performance
Next
From: Scott Ribe
Date:
Subject: Re: failover and switchover in postgresql