Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42999=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1XjTeP-0006Fe-Te
 for pgsql-admin@arkaria.postgresql.org; Wed, 29 Oct 2014 13:51:02 +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+M42999=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1XjTeP-0002TS-Dd
 for pgsql-admin@arkaria.postgresql.org; Wed, 29 Oct 2014 13:51:01 +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 1XjTeO-0002TM-Iu
 for pgsql-admin@postgresql.org; Wed, 29 Oct 2014 13:51:00 +0000
Received: from mail-qc0-x233.google.com ([2607:f8b0:400d:c01::233])
 by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <jayknowsunix@gmail.com>)
 id 1XjTeC-0007Ax-U0
 for pgsql-admin@postgresql.org; Wed, 29 Oct 2014 13:50:58 +0000
Received: by mail-qc0-f179.google.com with SMTP id o8so2275891qcw.38
 for <pgsql-admin@postgresql.org>; Wed, 29 Oct 2014 06:50:47 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=references:mime-version:in-reply-to:content-type
 :content-transfer-encoding:message-id:cc:from:subject:date:to;
 bh=k3DfxxJYhLRYaoNtzhtAY7BoWka0TEMblOi/Ba2MYMM=;
 b=h9UCAK6Y8Nos5/VUTpyjWlXKfauwpD7vbTzS2t7L6q4/JmLMwiFZ4xTDdfDoqe0dTw
 vQsrUWonC6fB4lqWRVpWABmqAhjyHjwkiZ9kQFNkrXFcaMsDYoCPn5DsUt0qwEryUgQq
 3efOojIr6RDzQujJlE9TLCXXddF0Ld0wr3VDtMkbQF/FmBdg6naCfKocUXqitvJBpV/j
 +lwyAgGuoM56qDUmJvnA1T9ddYtNcI4OZdSR80sLy90Su0y+JsvoBVJsuMP4zrJRd1P2
 mAnWAVc/cVwM5hARJfN+cf9IYsaDpnOA6+2JLnOupXkRYTuSFjpN0tZMNQNN1ftjpd2W
 7qfQ==
X-Received: by 10.140.48.233 with SMTP id o96mr2994457qga.47.1414590647212;
 Wed, 29 Oct 2014 06:50:47 -0700 (PDT)
Received: from [192.168.254.3] (h77.89.102.166.static.ip.windstream.net.
 [166.102.89.77])
 by mx.google.com with ESMTPSA id j1sm4152683qao.38.2014.10.29.06.50.45
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Wed, 29 Oct 2014 06:50:46 -0700 (PDT)
References: <5450E937.2070408@gmail.com>
 <3A8E2AE3D7AFB44F89EA82A873FBE4E655988BBE@DC-MBOX1.advisory.com>
Mime-Version: 1.0 (1.0)
In-Reply-To: <3A8E2AE3D7AFB44F89EA82A873FBE4E655988BBE@DC-MBOX1.advisory.com>
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Message-Id: <340AC30B-9188-44E5-8BC9-BBDB715EEF83@gmail.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
X-Mailer: iPad Mail (11D257)
From: jayknowsunix@gmail.com
Subject: Re: A local replication entry
Date: Wed, 29 Oct 2014 09:50:44 -0400
To: "Doiron, Daniel" <DoironD@advisory.com>
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

Daniel,

Thanks for the reply. I don't think psql would diagnose this as it wouldn't=
 use a replication connection, just a standard one. That is unless there is=
 a way to force a replication connection through psql, and I just don't kno=
w it. As it is, the postgres user has no issues getting in with psql, as in=
 "psql csg_db" with no other options specified.

I'm almost certain that my /etc/hosts file is up to date and I see all thre=
e of my db servers in it. There are no IPv6 entries in it at any event,

Sent from my iPad

> On Oct 29, 2014, at 9:43 AM, "Doiron, Daniel" <DoironD@advisory.com> wrot=
e:
>=20
> Do you get the same error using psql client?=20
>=20
> If so, do you see more connection details in the log? Is your /etc/hosts =
configured to resolve correctly? (I've had rogue sysadmins configure my ser=
vers to resolve to strange things like IPv6)
>=20
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgres=
ql.org] On Behalf Of John Scalia
> Sent: Wednesday, October 29, 2014 9:19 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] A local replication entry
>=20
> I think maybe it's just too early in the morning for me, but I can't seem=
 to get a local entry for replication working. I'm trying to create a scrip=
t for hourly backups using pg_basebackup, and here's the command I'm using:
>=20
> /usr/pgsql-9.3/bin/pg_basebackup -D - -Ft -z -c fast -l hourly.backup > b=
ackup_file.gz
>=20
> The entry in the pg_hba.conf file is:
>=20
> local    replication    postgres                            trust
>=20
> And the error is: FATAL: no pg_hba.conf entry for replication connection =
from host "[local]", user "postgres", SSL off, but I have gotten this to wo=
rk only if I use a "-h 10.10.1.129" option for the command. This only works=
 since another entry in the pg_hba.conf satisfies the command.
>=20
> Do I have an error with the local entry? Or are local entries even allowe=
d for replication? As this has to be automatically deployed to various serv=
ers, I'd prefer to NOT specify each host's IP address both in pg_hba.conf f=
ile and in the script calling the pg_basebackup command. Oh, and at some po=
int when this starts working, I am going to change the user from postgres t=
o another without superuser capability.
> --
> Jay
>=20
>=20
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make ch=
anges to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin