From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Psql: could not connect to server: No such file or directory
Date: Thu, 2 May 2019 15:07:12 -0500
Message-ID: <8b465695-f235-db58-1afd-024c22afd5dd@gmail.com> (raw)
In-Reply-To: <7b9d591c-13bb-7773-e5cb-79e75b4b3f8e@redo2oo.ch>
References: <363d3b8ca13a408c81d584a28d29da8e@BN1F00802MB0033.008f.mgd2.msft.net>
<7b9d591c-13bb-7773-e5cb-79e75b4b3f8e@redo2oo.ch>
He could edit the 9.6/data/postgresql.conf file and have it use a different
port, no?
On 5/2/19 1:34 PM, robert wrote:
>
> 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 <mailto:robert@redo2oo.ch>
> Sickingerstrasse 3, 3014 Bern <http://maps.apple.com/?q=Sickingerstrasse
> 3,3014 Bern>
>
> https://Redo2oo.ch <https://redo2oo.ch;
>
> *Ihr Partner wenn es um ERP Lösungen geht.*
>
--
Angular momentum makes the world go 'round.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Psql: could not connect to server: No such file or directory
In-Reply-To: <8b465695-f235-db58-1afd-024c22afd5dd@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox