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@vt.edu] Sent: Saturday, August 13, 2016 9:47 AM To: Murthy Nunna <mnunna@fnal.gov> Cc: pgsql-admin@postgresql.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@vt.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@fnal.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.
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
-- Robert W. Burgholzer 'Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity.' - Charles Mingus
-- Robert W. Burgholzer 'Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity.' - Charles Mingus
