Re: can't create a local server

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: msm(dot)scaglione(at)libero(dot)it, pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: can't create a local server
Date: 2020-06-10 06:43:13
Message-ID: d87c48ffb62982a4c4c127b24a2b9b6e87ed80db.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tue, 2020-06-09 at 19:03 +0200, msm(dot)scaglione(at)libero(dot)it wrote:
> This is my first to the list.
>
> Using pgadmin4 I can't create a local server "timeot expired"
> from debian buster terminal ask me to verify I'm allowed to connect to the unix domain socket /var/run/postgresql/.s.PGSQL.5432
>
>
> su
>
> Password:
>
> root(at)mycomputer:/home/me# su - postgres
>
> postgres(at)mycomputer:~$ psql
>
> psql: error: could not connect to server:
>
> File o directory non esistente Verifica che il server locale sia in funzione e che accetti connessioni sul socket di dominio Unix "/var/run/postgresql/.s.PGSQL.5432"
>
>
>
> I solved this problem with postgresql10 modifying a .conf file but file and directory names changed in postgresql 12
>
> Can you help me?

First, verify that the server is running and listening:

- are there PostgreSQL processes?

- What is "port" and "unix_socket_directories" in "postgresql.conf"?

Then it would be interesting to know what exactly you entered in pgAdmin
to specify the connection.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Greg Rychlewski (LCL) 2020-06-10 07:46:47 Monitoring Autovacuum Progress
Previous Message msm.scaglione 2020-06-09 17:03:54 can't create a local server