Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wdk9G-0006rL-LJ for pgsql-admin@arkaria.postgresql.org; Fri, 25 Apr 2014 17:42:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Wdk9F-0002wr-Ti for pgsql-admin@arkaria.postgresql.org; Fri, 25 Apr 2014 17:42:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wdk9F-0002wj-1k for pgsql-admin@postgresql.org; Fri, 25 Apr 2014 17:42:53 +0000 Received: from nm11-vm1.bullet.mail.bf1.yahoo.com ([98.139.213.152]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wdk98-0007bm-6T for pgsql-admin@postgresql.org; Fri, 25 Apr 2014 17:42:52 +0000 Received: from [98.139.215.142] by nm11.bullet.mail.bf1.yahoo.com with NNFMP; 25 Apr 2014 17:42:44 -0000 Received: from [98.139.212.213] by tm13.bullet.mail.bf1.yahoo.com with NNFMP; 25 Apr 2014 17:42:44 -0000 Received: from [127.0.0.1] by omp1022.mail.bf1.yahoo.com with NNFMP; 25 Apr 2014 17:42:44 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 665475.53386.bm@omp1022.mail.bf1.yahoo.com Received: (qmail 5207 invoked by uid 60001); 25 Apr 2014 17:42:44 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1398447764; bh=NhR7doJ20iUQ0tFANGhcCzssfQcbYEge2liUSR4mJzI=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=yn3cJjgLJ5GaFUGNToL6RQSXgUT1zNrM8J26Vto/nqn3mQByVz4CiYxYKda08KD5jXLgqyafkAxbYK0ei/PSrJc8lYPMDDodz2HnxYD7G9+jIw7rjaXmgjt5ykdxEx+qLcWmCLdA3QLyUKkIWcumy0uNggxI5xYcfkKRhD0zpIU= X-YMail-OSG: zEvijNAVM1lz3qsxeJve48qjUfKaazi3xiAV8f.kDl6UoyF ww1l4.a98RuycNORRkUm7I1i23d9gyXPhvZuUAtDupa5ajTcfOfNfvHU3584 7gzAoH9p1BJsklpxvKPawSFHYYltYSsfpGKxZXsp8GQRIs1Od.7OXYoYo8_m f63KSsYymF069Rbfg_zDWvHp13KPPIkzcRaxgh9X9oSoMx9fP3zcXqgALoBo 6rpfebsULiCEcyrv7aYcCozVUrHsF8TrrsLk7OPp0AciSLQYOV8gLhGDHOCu X_urN.bVkAAEI.SCRnWeac7lVhPBs8TUtw9nfQGSEl3WrBQu1wTmhYzFOOum qzmhy75ytD5BzALDT74e7OeduXQPi1WDVmG7lWnZHBkA23g_FlM7peydKSz3 7_nRSF_3q0fI0fbT2Islf5ZCG9dJhweGR_07OtqggAE7ZFJb0vFI48zA2JJe F7Vb6m9PbkqhP5NmFd8H.Gd9D1LhFhtNyO3VNjNWjFra.ZSyAG96H73.FQCL xcEDHgrU1yOqIP3BaEGau7_jpKRusxDrCFu2KOfaluAGD0YS2wQ-- Received: from [198.179.137.251] by web162705.mail.bf1.yahoo.com via HTTP; Fri, 25 Apr 2014 10:42:44 PDT X-Rocket-MIMEInfo: 002.001, CgpJJ20gdXNpbmcgUG9zdGdyZVNRTCA5LjIuNCBvbiB4ODZfNjQtdW5rbm93bi1saW51eC1nbnUsIGNvbXBpbGVkIGJ5IGdjYyAoR0NDKSA0LjEuMiAyMDA3MDExNSAoU1VTRSBMaW51eCksIDY0LWJpdC4KCkkgc2V0IHVwIHN0cmVhbWluZyByZXBsaWNhdGlvbiBmb3IgYSByZWFkL3dyaXRlIHByaW1hcnkgYW5kIGEgcmVhZC9vbmx5IApzdGFuZGJ5LiAgVGhlIHJlcGxpY2F0aW9uIHdvcmtzIGZpbmUgZm9yIGEgd2hpbGUsIGFuZCB0aGVuIG91dCBvZiB0aGUgCmJsdWUgQk9USCBtYWNoaW5lcyBiZWNvbWUgcmUBMAEBAQE- X-Mailer: YahooMailWebService/0.8.185.657 Message-ID: <1398447764.7937.YahooMailNeo@web162705.mail.bf1.yahoo.com> Date: Fri, 25 Apr 2014 10:42:44 -0700 (PDT) From: Henry Korszun Reply-To: Henry Korszun Subject: Streaming replication problem To: "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1391001287-2014647189-1398447764=:7937" X-Pg-Spam-Score: -2.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 --1391001287-2014647189-1398447764=:7937 Content-Type: text/plain; charset=us-ascii 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. --1391001287-2014647189-1398447764=:7937 Content-Type: text/html; charset=us-ascii

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.

--1391001287-2014647189-1398447764=:7937--