Re: Postgres v9.5.3 and v9.5.4 Unix Socket Issue

Hi Robert,

This is local connection from the same server where cluster is running. I don’t need hostname unless it is a change in 9.5. The same syntax (without hostname) worked in earlier versions.

Thanks,
Murthy

From: Robert Burgholzer [mailto:rburghol(at)vt(dot)edu]
Sent: Saturday, August 13, 2016 9:39 AM
To: Murthy Nunna <mnunna(at)fnal(dot)gov>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Postgres v9.5.3 and v9.5.4 Unix Socket Issue

psql (client rpm in 9.5) is not consistent with build default of 9.5 server rpm. Is that a possibility????

I suppose - but to verify it looks like your connection syntax is not really compatible with the socket style, docs say you should pass socket path with to the -h or --host - maybe pass your socket in as:

h hostname
--host=hostname

Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory for the Unix-domain socket.

--
--
Robert W. Burgholzer
'Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity.' - Charles Mingus
Athletics: http://athleticalgorithm.wordpress.com/
Science: http://robertwb.wordpress.com/
Wine: http://reesvineyard.wordpress.com/