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
