Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UUL95-0007BF-EL for pgsql-admin@arkaria.postgresql.org; Mon, 22 Apr 2013 18:07:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UUL94-00038w-A4 for pgsql-admin@arkaria.postgresql.org; Mon, 22 Apr 2013 18:07:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UUL8n-0002uV-Qj for pgsql-admin@postgresql.org; Mon, 22 Apr 2013 18:07:01 +0000 Received: from [64.207.29.137] (helo=mail.illumen.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UUL8k-0006zR-9X for pgsql-admin@postgresql.org; Mon, 22 Apr 2013 18:07:01 +0000 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CE3F84.2B298B38" Subject: Failover question Date: Mon, 22 Apr 2013 12:06:52 -0600 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Failover question Thread-Index: Ac4/gypYtwbM/7i2SS6qIcHgPWpjIA== From: "Benjamin Krajmalnik" To: X-Host-Lookup-Failed: Reverse DNS lookup failed for 64.207.29.137 (failed) X-Pg-Spam-Score: 1.6 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. ------_=_NextPart_001_01CE3F84.2B298B38 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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. =20 Thank you in advance, =20 Benjamin =20 =20 =20 ------_=_NextPart_001_01CE3F84.2B298B38 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

 

 

 

------_=_NextPart_001_01CE3F84.2B298B38--