Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WdkQk-0007X1-4C for pgsql-admin@arkaria.postgresql.org; Fri, 25 Apr 2014 18:00:58 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WdkQj-0000hZ-DR for pgsql-admin@arkaria.postgresql.org; Fri, 25 Apr 2014 18:00:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WdkQi-0000fN-3U for pgsql-admin@postgresql.org; Fri, 25 Apr 2014 18:00:56 +0000 Received: from mail.journyx.com ([209.163.206.41] helo=mail.int.journyx.com) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WdkQd-000803-6W for pgsql-admin@postgresql.org; Fri, 25 Apr 2014 18:00:54 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.int.journyx.com (Postfix) with ESMTP id 87605300227; Fri, 25 Apr 2014 13:00:48 -0500 (CDT) Received: from mail.int.journyx.com ([127.0.0.1]) by localhost (mail.int.journyx.com [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id 8yRLHaaW9cjG; Fri, 25 Apr 2014 13:00:43 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by mail.int.journyx.com (Postfix) with ESMTP id E2BCE3001D5; Fri, 25 Apr 2014 13:00:43 -0500 (CDT) X-Virus-Scanned: amavisd-new at mail.int.journyx.com Received: from mail.int.journyx.com ([127.0.0.1]) by localhost (mail.int.journyx.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id EiDOZ39R7V00; Fri, 25 Apr 2014 13:00:43 -0500 (CDT) Received: from mail.int.journyx.com (zimbra.int.journyx.com [192.168.100.5]) by mail.int.journyx.com (Postfix) with ESMTP id B6B9C3001C5; Fri, 25 Apr 2014 13:00:43 -0500 (CDT) Date: Fri, 25 Apr 2014 13:00:43 -0500 (CDT) From: Scott Whitney Reply-To: Scott Whitney To: Henry Korszun Cc: Scott Whitney , pgsql-admin@postgresql.org Message-ID: <2131729726.331419.1398448843621.JavaMail.zimbra@mail.int.journyx.com> In-Reply-To: <1398448636.25048.YahooMailNeo@web162704.mail.bf1.yahoo.com> References: <1398447433.8578.YahooMailNeo@web162701.mail.bf1.yahoo.com> <712112871.331097.1398447813672.JavaMail.zimbra@mail.int.journyx.com> <1398448636.25048.YahooMailNeo@web162704.mail.bf1.yahoo.com> Subject: Re: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_331418_10859782.1398448843619" X-Originating-IP: [192.168.100.188] X-Mailer: Zimbra 8.0.6_GA_5922 (ZimbraWebClient - GC34 (Win)/8.0.6_GA_5922) Thread-Topic: [ADMIN] Thread-Index: DtF6alpWXbEVSr6uGM7mwVV91Da0QA== X-Pg-Spam-Score: -2.5 (--) 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 ------=_Part_331418_10859782.1398448843619 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit The slave doesn't "turn off" the master. The trigger file is intended to be touched _when the master is down_. Since the master never WENT down (or came back up) and the trigger file was touched, the slave got promoted. You'll need to stop the slave, run your select pg_startbackup(), rsync, etc to get your slave back to slave mode. ----- Original Message ----- > There IS a trigger file, which does appear to have been "touch"ed. But the > problem is that a fail-over hasn't really occurred since the original > read/write primary continues to be a fully functioning read/write machine. > But it's no longer replicating to the erstwhile standby, which has become > read/write. Bottom line, I now have 2 read/write machines, but with no > replication between them. > On Friday, April 25, 2014 1:43 PM, Scott Whitney wrote: > Sounds like you might have a "trigger_file" set in your recovery.conf. Do > you? That or someone is issuing a pg_ctl promote command. > > I'm using PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc > > (GCC) > > 4.1.2 20070115 (SUSE Linux), 64-bit. > > > I set up streaming replication for a read/write primary and a read/only > > standby. The replication works fine for a while, and then out of the blue > > BOTH machines become read/write, but with no replication from the original > > primary to the newly read/write standby. > > > The only log entry that seems relevant is as follows: > > FATAL,57P01,"terminating walreceiver process due to administrator > > command",,,,,,,,"ProcessWalRcvInterrupts, walreceiver.c:150","" > > > Any help/guidance would be appreciated. Thanks in advance. > ------=_Part_331418_10859782.1398448843619 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
The slave doesn't "turn off" the= master. The trigger file is intended to be touched _when the master is dow= n_.

Since the master never WENT down (or came back= up) and the trigger file was touched, the slave got promoted.
You'll need to stop the slave, run your select pg_startbackup(= ), rsync, etc to get your slave back to slave mode.



There IS a trigger file, which doe= s appear to have been "touch"ed.  But the problem is that a fail-over = hasn't really occurred since the original read/write primary continues to b= e a fully functioning read/write machine. But it's no longer replicating to= the erstwhile standby, which has become read/write.  Bottom line, I n= ow have 2 read/write machines, but with no replication between them.
On Friday, April 25, 2014 1:43 PM, Scott Whitney <scott@journyx.com> wrote:
Sounds like you might have a "trigger_file" set in your recovery.conf. Do = you? That or someone is issuing a pg_ctl promote command.

I'm = using PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4= .1.2 20070115 (SUSE Linux), 64-bit.

I set up streaming replication for a read/write primary and a read/only=20 standby. The replication works fine for a while, and then out of the=20 blue BOTH machines become read/write, but with no replication from the=20 original primary to the newly read/write standby.

The only log entry that seems relevant is as follows:=20 FATAL,57P01,"terminating walreceiver process due to administrator=20 command",,,,,,,,"ProcessWalRcvInterrupts, walreceiver.c:150",""

Any help/guidance would be appreciated. Thanks in advance. =09=09 =20 =20 =20 =09=09=09=09



=

------=_Part_331418_10859782.1398448843619--