pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedfailover and switchover in postgresql
3+ messages / 3 participants
[nested] [flat]
* failover and switchover in postgresql
@ 2013-10-25 08:48 metsarin <metsarin@yahoo.com>
2013-10-25 17:02 ` Re: failover and switchover in postgresql Payal Singh <payal@omniti.com>
2013-10-25 17:07 ` Re: failover and switchover in postgresql Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 2 replies; 3+ messages in thread
From: metsarin @ 2013-10-25 08:48 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: failover and switchover in postgresql
2013-10-25 08:48 failover and switchover in postgresql metsarin <metsarin@yahoo.com>
@ 2013-10-25 17:02 ` Payal Singh <payal@omniti.com>
1 sibling, 0 replies; 3+ messages in thread
From: Payal Singh @ 2013-10-25 17:02 UTC (permalink / raw)
To: metsarin <metsarin@yahoo.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: failover and switchover in postgresql
2013-10-25 08:48 failover and switchover in postgresql metsarin <metsarin@yahoo.com>
@ 2013-10-25 17:07 ` Scott Ribe <scott_ribe@elevated-dev.com>
1 sibling, 0 replies; 3+ messages in thread
From: Scott Ribe @ 2013-10-25 17:07 UTC (permalink / raw)
To: metsarin <metsarin@yahoo.com>; +Cc: pgsql-admin
On Oct 25, 2013, at 2:48 AM, metsarin <metsarin@yahoo.com> wrote:
> Pls help me to explain how solve this problem.
> Thanks!
The very first thing you need to do is specify your version of PostgreSQL, because these features have seen significant changes in recent releases.
If you're just getting started, and can use the latest version, that would be best--and you need to say so...
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-10-25 17:07 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-10-25 08:48 failover and switchover in postgresql metsarin <metsarin@yahoo.com>
2013-10-25 17:02 ` Payal Singh <payal@omniti.com>
2013-10-25 17:07 ` Scott Ribe <scott_ribe@elevated-dev.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox