Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43005=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1XjVIu-0002DF-N0
 for pgsql-admin@arkaria.postgresql.org; Wed, 29 Oct 2014 15:36:56 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43005=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1XjVIu-0002Wq-78
 for pgsql-admin@arkaria.postgresql.org; Wed, 29 Oct 2014 15:36:56 +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 <jayknowsunix@gmail.com>)
 id 1XjVIp-0002O3-A2
 for pgsql-admin@postgresql.org; Wed, 29 Oct 2014 15:36:51 +0000
Received: from mail-yk0-x236.google.com ([2607:f8b0:4002:c07::236])
 by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <jayknowsunix@gmail.com>)
 id 1XjVIl-0000o1-BF
 for pgsql-admin@postgresql.org; Wed, 29 Oct 2014 15:36:48 +0000
Received: by mail-yk0-f182.google.com with SMTP id q200so1412673ykb.13
 for <pgsql-admin@postgresql.org>; Wed, 29 Oct 2014 08:36:46 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=message-id:date:from:user-agent:mime-version:to:cc:subject
 :references:in-reply-to:content-type:content-transfer-encoding;
 bh=uePQZxzGr5TV8pZdcxg27qJTB/tx7pyrZo3u/7O8sUA=;
 b=0OJmHupr4LEEQ7QwWBwzuIQBccOe1W0Ar7dQW4dcaZ5BD8LFAtE+Y/5rlHxnFsnnsl
 GUics4j5C4kCjIPUqwpc46WmfG3IYGb8jTpoo5CYwg6ry7Dr24gcog7oiKX2iPl92aps
 zT3rC8jVx1Z594DTAukW7gj2M5QkWnBpc0KS74mz6sjeL1zN3bPqMp9MQcPzZsCQe3SQ
 GTyFazICbDQr7DEZ1U0kmHE9+eR5LsfmVxCArnD6OSgeVmw6iqf/9wFhTh9Buc/jjB/U
 Inq/8ia1hDM/D0AOVYMl4G2KNLkP0SH6nZaGB0siZm5wgdDO92nuDDJQ0KcjFtITpOuy
 yZNQ==
X-Received: by 10.236.209.101 with SMTP id r65mr2306602yho.140.1414597006355;
 Wed, 29 Oct 2014 08:36:46 -0700 (PDT)
Received: from [192.168.254.2] (h77.89.102.166.static.ip.windstream.net.
 [166.102.89.77])
 by mx.google.com with ESMTPSA id z39sm2079493yhz.30.2014.10.29.08.36.44
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Wed, 29 Oct 2014 08:36:45 -0700 (PDT)
Message-ID: <54510950.90100@gmail.com>
Date: Wed, 29 Oct 2014 11:35:44 -0400
From: John Scalia <jayknowsunix@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:24.0) Gecko/20100101 Thunderbird/24.6.0
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: Shreeyansh dba <shreeyansh2014@gmail.com>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: A local replication entry
References: <5450E937.2070408@gmail.com>
 <CAGDYbUP3OewxxUNAf5DBBZPEwOWyEGbSBp3eKqq3F2+r6y-+Gw@mail.gmail.com>
 <5450FB3D.7030008@gmail.com> <23872.1414595142@sss.pgh.pa.us>
In-Reply-To: <23872.1414595142@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.7 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

I thought you might be correct, Tom, but I double-checked the postgresql.conf file and listen_addresses = "*". I had forgotten to look to see if netstat reported:

tcp    0    0    0.0.0.0:5432            0.0.0.0:*        LISTEN

But even with that established, the pg_basebackup using:

/usr/pgsql-9.3/bin/pg_basebackup -D - -h 127.0.0.1 -Ft -z -c fast -l hourly.backup > backup_file.gz                or
/usr/pgsql-9.3/bin/pg_basebackup -D - -h 127.0.0.1 -U postgres -Ft -z -c fast -l hourly.backup > backup_file.gz

are still failing with:

pg_basebackup: could not connect to server: FATAL: no pg_hba.conf entry for replication connection from host "127.0.0.1", user "postgres", SSL off

The line from the pg_hba.conf file currently reads:

host    replication    postgres    127.0.0.1/32    trust

I really don't see where the problem is, and I know I've done a reload after every change in the pg-hba.conf.

On 10/29/2014 11:05 AM, Tom Lane wrote:
> John Scalia <jayknowsunix@gmail.com> 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