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

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
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-15 20:03:28
Message-ID: 20170515200328.GA26257@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, May 15, 2017 at 12:55:48PM -0700, Ken Tanzer wrote:
> Hi. On a Centos 6.9 server (in the cloud with Rackspace), I'm wanting to
> install PGDG 9.6 alongside the already-running 9.2. After installing the
> 9.6 packages (and even before doing an initdb), I am no
> longer able to make a local connection to the 9.2 server. Instead I get
> the message:

See eg.
https://www.postgresql.org/message-id/21044.1326496507@sss.pgh.pa.us
https://www.postgresql.org/message-id/0A21BC93-7B9C-476E-AAF4-0FF71708E87F@elevated-dev.com

I'm guessing you upgraded the client libraries, which probably change the
(default) socket path.

Your options are to specify path to the socket (maybe in /tmp for running
PG92?), change to TCP connection, or specify server option
unix_socket_directories.

Justin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-05-15 20:05:01 Re: Help: Installing 9.6 breaks local connections to 9.2 on Centos 6.9
Previous Message Ken Tanzer 2017-05-15 19:55:48 Help: Installing 9.6 breaks local connections to 9.2 on Centos 6.9