Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XjUon-0000xD-9F for pgsql-admin@arkaria.postgresql.org; Wed, 29 Oct 2014 15:05:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XjUom-0005LK-Ca for pgsql-admin@arkaria.postgresql.org; Wed, 29 Oct 2014 15:05:48 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XjUol-0005LD-IQ for pgsql-admin@postgresql.org; Wed, 29 Oct 2014 15:05:47 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XjUoi-0000EA-RR for pgsql-admin@postgresql.org; Wed, 29 Oct 2014 15:05:45 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id s9TF5gow023873; Wed, 29 Oct 2014 11:05:42 -0400 From: Tom Lane To: John Scalia cc: Shreeyansh dba , "pgsql-admin@postgresql.org" Subject: Re: A local replication entry In-reply-to: <5450FB3D.7030008@gmail.com> References: <5450E937.2070408@gmail.com> <5450FB3D.7030008@gmail.com> Comments: In-reply-to John Scalia message dated "Wed, 29 Oct 2014 10:35:41 -0400" Date: Wed, 29 Oct 2014 11:05:42 -0400 Message-ID: <23872.1414595142@sss.pgh.pa.us> 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 John Scalia writes: > And I performed a "service postgresql-9.3 reload", and it still failed with the same error. Then, I tried again using a "-h 127.0.0.1" option for the pg_basebackup. That complained > "pg_basebackup: could not connect to server: connection refused." So, I did a "netstat -an | grep 5432" and I see that postgresql is not listening on that port for 127.0.0.1. Hm, that suggests your problem is with the setting of listen_addresses, not just what's in pg_hba.conf. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin