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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Devrim Gündüz <devrim(at)gunduz(dot)org>, Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: 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-16 14:03:54
Message-ID: cda2a838-f90a-6dc3-8ae6-d75420f79cc0@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 05/16/2017 01:00 AM, Devrim Gündüz wrote:
>
> Hi,
>
> On Mon, 2017-05-15 at 22:35 -0700, Ken Tanzer wrote:
>> https://redmine.postgresql.org/issues/2409
>
> Not sure whether we should *fix* this or not on RPM side. This may break some
> of the existing installations, right?
>
> I'm not objecting, just asking for opinions.

To me the principle of least surprise says that it should be fixed. At
this point a pre-9.4 server is putting its socket where the primary
client library(libpq) to said server cannot find it if a 9.4+ server is
installed. The options seem to be:

1) Use the libpq appropriate for each Postgres version.

2) Modify the postgresql.conf to point at the socket directory that the
controlling libpq is looking for. I could see this being messy.

3) Document the change in behavior. Possibly here:

https://www.postgresql.org/download/linux/redhat/

PostgreSQL Yum Repository

>
> Regards,
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-05-16 14:17:11 Re: Different query plan used for the same query depending on how parameters are passed
Previous Message Adrian Klaver 2017-05-16 13:42:59 Re: EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2