On 01/25/2017 09:35 AM, Tom Lane wrote:
> Steve Crawford <scrawford@pinpointresearch.com> writes:
>> Adrian asks the correct questions. Lacking the answers to those I'm going
>> to venture a guess that a Unix-domain socket exists but access via
>> Unix-domain sockets is somehow blocked, probably by pg_hba.conf.
> Actually, the more common case I've seen is that the server put the
> socket file in directory X but psql (or more specifically libpq)
> is looking in directory Y. Try "show unix_socket_directories"
> (or on older server versions "show unix_socket_directory") in a
> successful connection, and compare to the path that psql shows when
> bleating that it can't connect.
>
> Usually this isn't operator error per se, but inconsistent defaults
> between builds obtained from different sources.
>
> regards, tom lane
Thanks Tom;
This was the issue...