Re: Psql: could not connect to server: No such file or directory

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(at)redo2oo(dot)ch <mailto:robert(at)redo2oo(dot)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.