Re: pgadmin4 on Ubuntu

[Yogesh Mahajan <yogesh.mahajan@xxxxxxxxxxxxxxxx>]

Hi,

Can you please try connecting postgres via psql? You might need to update the postgres setting mentioned over here.

Once you are able to connect with psql via terminal, you should be able to connect using pgAdmin too.

Thanks,

Yogesh Mahajan

EnterpriseDB

On Wed, Sep 21, 2022 at 11:05 AM Adriano Peluso <adriano.peluso@xxxxxxxxxxxxxxxxx> wrote:

Hello,

I installed pgadmin4 on Ubuntu 22.04 through apt, following the instructions found here

https://www.pgadmin.org/download/pgadmin-4-apt/

I have a postgresql service running locally, installed with apt too

I'd like to connect pgadmin4 to the locally running postgres, possibly through a Unix socket

I have this

$ sudo ls -lha /var/run/postgresql/
totale 0
drwxrwsr-x  3 postgres postgres   60 set 21 07:08 .
drwxr-xr-x 42 root     root     1,2K set 21 07:08 ..
drwxr-s---  2 postgres postgres   40 set 21 07:08 14-main.pg_stat_tmp

I tried to create a connection in pgadmin4 but an error message reported: 

connection to server on socket

/var/run/postgresql/.s.PGSQL.5432

No such file or directory

Is the server running locally and accepting connections on that socket ?

Well, I don't know

I understand ths is more related to Ubuntu than it is to pgadmin4

Still I think it's appropriate to post here

Thanks for any hint