pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFailover question
2+ messages / 2 participants
[nested] [flat]
* Failover question
@ 2013-04-22 18:06 Benjamin Krajmalnik <kraj@servoyant.com>
2013-04-22 18:11 ` Re: Failover question Walter Hurry <walterhurry@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Benjamin Krajmalnik @ 2013-04-22 18:06 UTC (permalink / raw)
To: pgsql-admin
I currently have 2 servers running PostgreSQL 9.0 under FreeBSD
configured with streaming replication.
DB1 is the primary server, and DB2 is the replicated server, which is
used for all of the read only queries.
I am having some hardware issues on DB1 which is affecting its
performance, resulting in data getting queued up.
I would like to change roles on these servers, such that DB1 becomes the
replicated server and DB2 the master server.
This is a production system, so I cannot take any chances of anything
going wrong.
What is the correct procedure for accomplishing this?
If needed, although not preferred, I can take the system offline for a
maintenance window.
Thank you in advance,
Benjamin
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Failover question
2013-04-22 18:06 Failover question Benjamin Krajmalnik <kraj@servoyant.com>
@ 2013-04-22 18:11 ` Walter Hurry <walterhurry@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Walter Hurry @ 2013-04-22 18:11 UTC (permalink / raw)
To: pgsql-admin
On Mon, 22 Apr 2013 12:06:52 -0600, Benjamin Krajmalnik wrote:
> I currently have 2 servers running PostgreSQL 9.0 under FreeBSD
> configured with streaming replication.
>
> DB1 is the primary server, and DB2 is the replicated server, which is
> used for all of the read only queries.
>
> I am having some hardware issues on DB1 which is affecting its
> performance, resulting in data getting queued up.
>
> I would like to change roles on these servers, such that DB1 becomes the
> replicated server and DB2 the master server.
>
> This is a production system, so I cannot take any chances of anything
> going wrong.
>
> What is the correct procedure for accomplishing this?
The correct procedure is to have a test server and test standby so that
you can test.
--
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] 2+ messages in thread
end of thread, other threads:[~2013-04-22 18:11 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-04-22 18:06 Failover question Benjamin Krajmalnik <kraj@servoyant.com>
2013-04-22 18:11 ` Walter Hurry <walterhurry@gmail.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