Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hMHAj-0004OJ-OA for pgsql-admin@arkaria.postgresql.org; Thu, 02 May 2019 19:15:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hMHAi-0000s5-9W for pgsql-admin@arkaria.postgresql.org; Thu, 02 May 2019 19:15:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hMGX9-0004sF-RD for pgsql-admin@lists.postgresql.org; Thu, 02 May 2019 18:34:15 +0000 Received: from susanne.redcor.ch ([178.63.103.72]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hMGX1-0002yK-MV for pgsql-admin@postgresql.org; Thu, 02 May 2019 18:34:14 +0000 Received: from [192.168.0.220] (84-72-41-4.dclient.hispeed.ch [84.72.41.4]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: robert@redo2oo.ch) by susanne.redcor.ch (Postfix) with ESMTPSA id 9F69CA047A; Thu, 2 May 2019 20:34:04 +0200 (CEST) Subject: Re: Psql: could not connect to server: No such file or directory To: SAMMY CRISWELL , pgsql-admin References: <363d3b8ca13a408c81d584a28d29da8e@BN1F00802MB0033.008f.mgd2.msft.net> From: robert Message-ID: <7b9d591c-13bb-7773-e5cb-79e75b4b3f8e@redo2oo.ch> Date: Thu, 2 May 2019 20:34:03 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.6.1 MIME-Version: 1.0 In-Reply-To: <363d3b8ca13a408c81d584a28d29da8e@BN1F00802MB0033.008f.mgd2.msft.net> Content-Type: multipart/alternative; boundary="------------F6C5680709F4271A8CA95BE7" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------F6C5680709F4271A8CA95BE7 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit when you install PostgreSQL the installation copies all its binaries to their respective places and tries to start the server afterwards. This of course fails as the needed ports are already used by the running old PostgreSQL server. So you end up with a mixture of new and old. No idea whether it will be enough to stop the running PostgreSQL and the just restart the PostgreSQL service .. robert On 02.05.19 17:50, SAMMY CRISWELL wrote: > > Good morning, > > I am preparing to upgrade my pqsl server from 9.3.5 to 9.6.12. I have > installed the 9.6 rpm onto the server that has 9.3.5 running. Postgres > is still running 9.3.5 on that server, but when I try to run psql I > get the following message. > > “psql: could not connect to server: No such file or directory > >         Is the server running locally and accepting > >         connections on Unix domain socket > "/var/run/postgresql/.s.PGSQL.5432"?” > > The database is still running and working I just can’t use any of the > client commands like psql, pg_dump…. > > And there is no "/var/run/postgresql/.s.PGSQL.5432" file. > > Can someone help with this problem. > > *Sam Criswell*| Senior Systems Engineer I > > InfrastructureEngineering > Intelligence, Information and Services (IIS) > > CityLine Phone: +1 972.664.8870* > Raytheon Company* > 1737 East Cityline Drive | Richardson, TX 75082 USA > > *Upcoming PTO: * > -- Robert Rottermann CEO 031 333 10 20 robert@redo2oo.ch Sickingerstrasse 3, 3014 Bern https://Redo2oo.ch *Ihr Partner wenn es um ERP Lösungen geht.* --------------F6C5680709F4271A8CA95BE7 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: 8bit

when you install PostgreSQL the installation copies all its binaries to their respective places and tries to start the server  afterwards.

This of course fails as the needed ports are already used by the running old PostgreSQL server.

So you end up with a mixture of new and old.

No idea whether it will be enough to stop the running PostgreSQL and the just restart the PostgreSQL service ..


robert

On 02.05.19 17:50, SAMMY CRISWELL wrote:

Good morning,

 

I am preparing to upgrade my pqsl server from 9.3.5 to 9.6.12. I have installed the 9.6 rpm onto the server that has 9.3.5 running. Postgres is still running 9.3.5 on that server, but when I try to run psql I get the following message.

 

“psql: could not connect to server: No such file or directory

        Is the server running locally and accepting

        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?”

The database is still running and working I just can’t use any of the client commands like psql, pg_dump….

And there is no "/var/run/postgresql/.s.PGSQL.5432" file.

 

Can someone help with this problem.

 

Sam Criswell | Senior Systems Engineer I

Infrastructure Engineering
Intelligence, Information and Services (IIS)

CityLine Phone: +1 972.664.8870
Raytheon Company
1737 East Cityline Drive | Richardson, TX 75082 USA

 

Upcoming PTO:

 

--
Robert Rottermann CEO

031 333 10 20
robert@redo2oo.ch
Sickingerstrasse 3, 3014 Bern

https://Redo2oo.ch
Ihr Partner wenn es um ERP Lösungen geht.
--------------F6C5680709F4271A8CA95BE7--