Re: [GENERAL] Help: Installing 9.6 breaks local connections to 9.2 on Centos 6.9 - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] Help: Installing 9.6 breaks local connections to 9.2 on Centos 6.9
Date
Msg-id 28477.1494880454@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Help: Installing 9.6 breaks local connections to 9.2 onCentos 6.9  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: [GENERAL] Help: Installing 9.6 breaks local connections to 9.2on Centos 6.9
List pgsql-general
Adrian Klaver <adrian.klaver@aklaver.com> writes:
> On 05/15/2017 01:10 PM, Devrim Gündüz wrote:
>> * You can connect to 9.2 using /usr/pgsql-9.2/bin/psql command. It knows the
>> old socket directory.

> That was where I was going until I saw this in the OP:

> bash-4.1$ /usr/pgsql-9.2/bin/psql -p 5432
> psql: could not connect to server: Connection refused
>     Is the server running locally and accepting
>     connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

The default is actually compiled into libpq.so, not psql itself.
So I'm thinking what's happening here is the 9.2 psql is picking
up a libpq.so supplied by 9.6.

            regards, tom lane


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Help: Installing 9.6 breaks local connections to 9.2 onCentos 6.9
Next
From: Ronny Abraham
Date:
Subject: Re: [GENERAL] Insert performance and disk usage in JSON vs JSONB