Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WdkAB-0006sp-S6 for pgsql-admin@arkaria.postgresql.org; Fri, 25 Apr 2014 17:43:52 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WdkAA-00040j-VB for pgsql-admin@arkaria.postgresql.org; Fri, 25 Apr 2014 17:43:51 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WdkA8-0003vv-1k for pgsql-admin@postgresql.org; Fri, 25 Apr 2014 17:43:48 +0000 Received: from mail.journyx.com ([209.163.206.41] helo=mail.int.journyx.com) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WdkA5-0000y2-IY for pgsql-admin@postgresql.org; Fri, 25 Apr 2014 17:43:47 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.int.journyx.com (Postfix) with ESMTP id EDDBD30021C; Fri, 25 Apr 2014 12:43:43 -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 a5BoScH33Qe8; Fri, 25 Apr 2014 12:43:34 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by mail.int.journyx.com (Postfix) with ESMTP id EFAE8300224; Fri, 25 Apr 2014 12:43:33 -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 pqRh4TYEiDsW; Fri, 25 Apr 2014 12:43:33 -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 C3F8D30021C; Fri, 25 Apr 2014 12:43:33 -0500 (CDT) Date: Fri, 25 Apr 2014 12:43:33 -0500 (CDT) From: Scott Whitney Reply-To: Scott Whitney To: Henry Korszun Cc: pgsql-admin@postgresql.org Message-ID: <712112871.331097.1398447813672.JavaMail.zimbra@mail.int.journyx.com> In-Reply-To: <1398447433.8578.YahooMailNeo@web162701.mail.bf1.yahoo.com> References: <1398447433.8578.YahooMailNeo@web162701.mail.bf1.yahoo.com> Subject: Re: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_331096_420288322.1398447813670" 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: PmThk1q+A+rd7/c7yYEr9348YbygGg== X-Pg-Spam-Score: 0.1 (/) 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_331096_420288322.1398447813670 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit 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. ----- Original Message ----- > 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_331096_420288322.1398447813670 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit
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_331096_420288322.1398447813670--