Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wdk3s-0006eb-3m for pgsql-admin@arkaria.postgresql.org; Fri, 25 Apr 2014 17:37:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Wdk3r-000117-Et for pgsql-admin@arkaria.postgresql.org; Fri, 25 Apr 2014 17:37:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wdk3q-00010z-Cl for pgsql-admin@postgresql.org; Fri, 25 Apr 2014 17:37:18 +0000 Received: from nm18-vm0.bullet.mail.bf1.yahoo.com ([98.139.213.138]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wdk3n-0007WT-IC for pgsql-admin@postgresql.org; Fri, 25 Apr 2014 17:37:17 +0000 Received: from [98.139.215.141] by nm18.bullet.mail.bf1.yahoo.com with NNFMP; 25 Apr 2014 17:37:14 -0000 Received: from [98.139.212.213] by tm12.bullet.mail.bf1.yahoo.com with NNFMP; 25 Apr 2014 17:37:14 -0000 Received: from [127.0.0.1] by omp1022.mail.bf1.yahoo.com with NNFMP; 25 Apr 2014 17:37:13 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 996066.38639.bm@omp1022.mail.bf1.yahoo.com Received: (qmail 86620 invoked by uid 60001); 25 Apr 2014 17:37:13 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1398447433; bh=asIF3jfCaOdwHbKSW1ibntPa6ZFZ40N3robUDn1I48M=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:To:MIME-Version:Content-Type; b=DmGSx4muLobrFheQ1B01Hx3Ge21l3qDV+voPLk6dQYIhqN0t25XfQ2ReFyRG6uBg4WznjeHymVuEc7coHF0XFtVoU45E1RCUQJ4SIG9lAA5YXj+rVbipVfrVVkm2GMkCCfi0/LD8KayyooV2mELGLXIlInAGOjjASYU6pS63VgA= X-YMail-OSG: bebkXSQVM1mCG.ZqB_iqzyotXAPAkNb5L8IF86MGyw4XoOY DEgAm7RBtUk.nWzleW.urecxrzv5PBDtgetdWHYISbwpbJ_XGNdavYe8ATu. _Re6qsL_o4fa1q7Hm62C2aUr_IzkXzrrUorJY63zhjjdVfqc4wd7XfTyMZCo IgKEjr9F.nYUyuuxnIcrTxI8GDRsj4WmF4jlqlGVEnU20TyzSKYXWhjUft3u 3y0K3lTmVO.Wasbx8n8rrLGvhsjd0_LFudXdAjwur9YBzAOXIto8oj9moKsM UDQUM5WzL4r4MxadMJwXl4V88uuF4itvNUsVnfcTpjHfNMujYbgSovwOLvTD inaLkeF.PTUqOEbSuW204Rpq9PBIngk7LPtMYsiBhhxBw9bHVHb_6Qn36skh JSPftFJsy8uYDmdWN_DKItUz3UYmVXRpIPvIS.3i3EJyNSB20cUkHnvH8n3e 0uI41s4SVxvYdXqcP0X.U5Gfdrs0agOW76Z3ooFhAgKvQCCeZ9apjgbF0M5J c1HbYpVhpExdFS6HNyFJYxxdh8kkv5rBEkkw2TJd1RUhBHHfeexurfw-- Received: from [198.179.137.251] by web162701.mail.bf1.yahoo.com via HTTP; Fri, 25 Apr 2014 10:37:13 PDT X-Rocket-MIMEInfo: 002.001, SSdtIHVzaW5nIFBvc3RncmVTUUwgOS4yLjQgb24geDg2XzY0LXVua25vd24tbGludXgtZ251LCBjb21waWxlZCBieSBnY2MgKEdDQykgNC4xLjIgMjAwNzAxMTUgKFNVU0UgTGludXgpLCA2NC1iaXQuCgpJIHNldCB1cCBzdHJlYW1pbmcgcmVwbGljYXRpb24gZm9yIGEgcmVhZC93cml0ZSBwcmltYXJ5IGFuZCBhIHJlYWQvb25seSAKc3RhbmRieS4gIFRoZSByZXBsaWNhdGlvbiB3b3JrcyBmaW5lIGZvciBhIHdoaWxlLCBhbmQgdGhlbiBvdXQgb2YgdGhlIApibHVlIEJPVEggbWFjaGluZXMgYmVjb21lIHJlYWQBMAEBAQE- X-Mailer: YahooMailWebService/0.8.185.657 Message-ID: <1398447433.8578.YahooMailNeo@web162701.mail.bf1.yahoo.com> Date: Fri, 25 Apr 2014 10:37:13 -0700 (PDT) From: Henry Korszun Reply-To: Henry Korszun To: "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-350752386-2048537369-1398447433=:8578" X-Pg-Spam-Score: -0.4 (/) 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 ---350752386-2048537369-1398447433=:8578 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. ---350752386-2048537369-1398447433=:8578 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.

---350752386-2048537369-1398447433=:8578--