From: Tom Lane <tgl@sss.pgh.pa.us>
To: Scott Marlowe <scott.marlowe@gmail.com>
cc: kschindl <chuck666xx@gmail.com>,
        "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: listen_addresses = '*' postgresql 9.5 does not allow local
 connect
In-reply-to: 
 <CAOR=d=1rj6fPgBLvDR+uVR0AzW92knufguzKNXyUFV1hwgyCeg@mail.gmail.com>
References: <1496544711321-5964669.post@n3.nabble.com>
 <CAOR=d=1rj6fPgBLvDR+uVR0AzW92knufguzKNXyUFV1hwgyCeg@mail.gmail.com>
Comments: In-reply-to Scott Marlowe <scott.marlowe@gmail.com>
	message dated "Sat, 03 Jun 2017 23:01:13 -0600"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <16590.1496553637.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Sun, 04 Jun 2017 01:20:37 -0400
Message-ID: <16591.1496553637@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Sat, Jun 3, 2017 at 8:51 PM, kschindl <chuck666xx@gmail.com> wrote:
>> when i add the listen_addresses =3D '*' i cannot connect local (with or =
without
>> pgadmin)
>> as soon as i comment this out i can connect local where the server is
>> installed

> Is there another listen_addresses line in your conf file?

I'd counsel looking into the postmaster log file.  The described symptoms
sound like the postmaster is failing to start when given this setting,
and the log should offer some clue as to why.

I think we've seen similar reports that eventually traced to local DNS
misconfiguration, but that's theorizing in advance of the evidence.

			regards, tom lane


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