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

Hi Robert,

I tried with –h /tmp and IT WORKED (in 9.5).

I looked at 9.3 and 9.5 psql command documentation. There is no change.

In 9.3 psql local connection worked without –h but in 9.5 psql it seems it is mandatory. If anybody could kindly point me to this change in behavior I really appreciate it.

Thanks,
Murthy

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

So it looks like it wants -h /tmp

On Saturday, August 13, 2016, Robert Burgholzer <rburghol(at)vt(dot)edu<mailto:rburghol(at)vt(dot)edu>> wrote:
I get that it's a local connection, but the documentation says that you should specify the directory path to that local connection in the host name parameter (at least) in the 9.5 version

On Saturday, August 13, 2016, Murthy Nunna <mnunna(at)fnal(dot)gov<javascript:_e(%7B%7D,'cvml','mnunna(at)fnal(dot)gov');>> wrote:
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<mailto:mnunna(at)fnal(dot)gov>>
Cc: pgsql-admin(at)postgresql(dot)org<mailto: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/

--
--
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/

--
--
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/