From: Tom Lane <tgl@sss.pgh.pa.us>
To: John Scalia <jayknowsunix@gmail.com>
Cc: 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 14:35:39 -0400
Message-ID: <29188.1414607739@sss.pgh.pa.us> (raw)
In-Reply-To: <545126F0.2090704@gmail.com>
References: <5450E937.2070408@gmail.com>
<CAGDYbUP3OewxxUNAf5DBBZPEwOWyEGbSBp3eKqq3F2+r6y-+Gw@mail.gmail.com>
<5450FB3D.7030008@gmail.com>
<23872.1414595142@sss.pgh.pa.us>
<54510950.90100@gmail.com>
<25754.1414599609@sss.pgh.pa.us>
<545126F0.2090704@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
John Scalia <jayknowsunix@gmail.com> writes:
> ... So, it really is using the correct pg_hba.conf.
Yeah, sure looks that way.
> Allow me to note, in closing, that this particular VM: csgha2 has been a problem child since it was built, and many things have been broken on it. I don't know if this is another
> one of the very hard-to-solve problems or not. I may try this on another of my sandbox systems. Still I need to know why this is failing.
Interesting, though it doesn't offer any very clear theory for what's
going on here.
The only theory I've got at this point is that somehow the address
matching code is failing to match the incoming connection to the spec
"127.0.0.1/32", perhaps because the platform's libc is filling in the
sockaddr struct weirdly. check_ip() and pg_range_sockaddr() would be
the things to look at if you care to try to trace through the code.
You could also experiment, for instance does 0.0.0.0/0 successfully
match?
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
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: tgl@sss.pgh.pa.us, jayknowsunix@gmail.com, shreeyansh2014@gmail.com
Subject: Re: A local replication entry
In-Reply-To: <29188.1414607739@sss.pgh.pa.us>
* 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