Re: 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> 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>
>> *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/
>>
>>
>>
>
>
> --
> --
> 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/