From: John Scalia <jayknowsunix@gmail.com>
To: Shreeyansh dba <shreeyansh2014@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: A local replication entry
Date: Wed, 29 Oct 2014 10:35:41 -0400
Message-ID: <5450FB3D.7030008@gmail.com> (raw)
In-Reply-To: <CAGDYbUP3OewxxUNAf5DBBZPEwOWyEGbSBp3eKqq3F2+r6y-+Gw@mail.gmail.com>
References: <5450E937.2070408@gmail.com>
<CAGDYbUP3OewxxUNAf5DBBZPEwOWyEGbSBp3eKqq3F2+r6y-+Gw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Ok, the line now reads:
host replication postgres 127.0.0.1/32 trust
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.
On 10/29/2014 9:58 AM, Shreeyansh dba wrote:
> I suspect there is a small modification is required in pg_hba.conf file ::
>
> Remove the '#' and modify the line like :: 'host replication postgres 127.0.0.1/32 <http://127.0.0.1/32; trust'
>
> I hope this will help you to resolve the issue
>
> Thanks and Regards
>
> Ajinkya Bangale
> www.shreeyansh.com <http://www.shreeyansh.com;
>
> On Wed, Oct 29, 2014 at 6:48 PM, John Scalia <jayknowsunix@gmail.com <mailto:jayknowsunix@gmail.com>> wrote:
>
> 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 script for hourly backups using
> pg_basebackup, and here's the command I'm using:
>
> /usr/pgsql-9.3/bin/pg_basebackup -D - -Ft -z -c fast -l hourly.backup > backup_file.gz
>
> The entry in the pg_hba.conf file is:
>
> local replication postgres trust
>
> 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 work 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.
>
> Do I have an error with the local entry? Or are local entries even allowed for replication? As this has to be automatically deployed to various servers, I'd prefer to NOT
> specify each host's IP address both in pg_hba.conf file and in the script calling the pg_basebackup command. Oh, and at some point when this starts working, I am going to
> change the user from postgres to another without superuser capability.
> --
> Jay
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org <mailto:pgsql-admin@postgresql.org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jayknowsunix@gmail.com, shreeyansh2014@gmail.com
Subject: Re: A local replication entry
In-Reply-To: <5450FB3D.7030008@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox