Re: Help: Installing 9.6 breaks local connections to 9.2 on Centos 6.9

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Devrim Gündüz <devrim(at)gunduz(dot)org>, Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Help: Installing 9.6 breaks local connections to 9.2 on Centos 6.9
Date: 2017-05-15 20:34:14
Message-ID: 28477.1494880454@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ronny Abraham 2017-05-15 20:39:19 Re: Insert performance and disk usage in JSON vs JSONB
Previous Message Adrian Klaver 2017-05-15 20:19:52 Re: Help: Installing 9.6 breaks local connections to 9.2 on Centos 6.9