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

From: Robert Burgholzer <rburghol(at)vt(dot)edu>
To: Murthy Nunna <mnunna(at)fnal(dot)gov>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Postgres v9.5.3 and v9.5.4 Unix Socket Issue
Date: 2016-08-13 14:46:18
Message-ID: CACT-NGKWCHUg8vwSimyc1e+wM1Y8uQU6Jt858Gj4a9hr5agUNw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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> 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
> <javascript:_e(%7B%7D,'cvml','rburghol(at)vt(dot)edu');>]
> *Sent:* Saturday, August 13, 2016 9:39 AM
> *To:* Murthy Nunna <mnunna(at)fnal(dot)gov
> <javascript:_e(%7B%7D,'cvml','mnunna(at)fnal(dot)gov');>>
> *Cc:* pgsql-admin(at)postgresql(dot)org
> <javascript:_e(%7B%7D,'cvml','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/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Burgholzer 2016-08-13 14:47:17 Re: Postgres v9.5.3 and v9.5.4 Unix Socket Issue
Previous Message Murthy Nunna 2016-08-13 14:43:03 Re: Postgres v9.5.3 and v9.5.4 Unix Socket Issue