From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ekaterina Amez <ekaterina.amez@zunibal.com>
cc: pgsql-admin@lists.postgresql.org
Subject: Re: Files overwritten when installing v9.6 in machine with v8.4
 previously running
In-reply-to: <221d54aa-e272-f9a9-0a8b-ead42bee43c1@zunibal.com>
References: <4cd198c1-5035-9374-500d-a7167b6ae05e@zunibal.com>
 <00bea3ea-ee92-00cb-8b27-1e82d4e4a6e9@gmail.com>
 <221d54aa-e272-f9a9-0a8b-ead42bee43c1@zunibal.com>
Comments: In-reply-to Ekaterina Amez <ekaterina.amez@zunibal.com>
	message dated "Mon, 30 Sep 2019 16:13:32 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <26004.1569854873.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Mon, 30 Sep 2019 10:47:53 -0400
Message-ID: <26005.1569854873@sss.pgh.pa.us>
Precedence: bulk

Ekaterina Amez <ekaterina.amez@zunibal.com> writes:
> I first thought they were going to be installed in their own 
> directories, but I'm starting to think that I'm missing something during 
> instalation process or maybe I'm missing something at deeper level 
> (probably lack of knowledge about linux and postgres). The thing is 
> after installing v9.6, having both versions running, I can't connect to 
> the older one and I'm having the message:  "no such file or directory. 
> Is the server running locally and accepting connections on Unix domain 
> socket "/var/run/postgresql/.s.PGSQL.5432"?".

This is probably a case of confusion about where the Unix socket file is.
There are competing standards about that: as we ship it, that file will
be in /tmp, but some Linux vendors make it be /var/run/postgresql because
of filesystem layout rules.  You are evidently using a libpq that was
built to default to /var/run/postgresql --- and since we can see that
you have a postmaster running on port 5432, it must have put its socket
file somewhere else, which I'm going to jump to the conclusion is /tmp.

You can override the client's default socket directory via something
like

	psql -h /tmp ...

A better long-term fix might be to change the postmaster's
unix_socket_directory(ies) setting to agree with what the
updated client library expects.

			regards, tom lane