Re: listen_addresses = '*' postgresql 9.5 does not allow local connect

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Scott Marlowe <scott.marlowe@xxxxxxxxx> writes:
> On Sat, Jun 3, 2017 at 8:51 PM, kschindl <chuck666xx@xxxxxxxxx> wrote:
>> when i add the listen_addresses = '*' 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


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




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux