Postgres server is running locally but refusing connection

Question

After installing postgres and pgAdmin 4 on Ubuntu 22.04 I want to setup a server listening on localhost.

The pg service is running

but when trying to create a new server I get the following error

I think the terminal error points to the same problem

I think the server is running locally but what am I missing / how can I accept the missing socket connections?

Check the database server's logfile. In my experience service ... status is rarely helpful. — jjanes
– jjanes, Commented Nov 14, 2022 at 2:34

Lusine Yakovleva · Accepted Answer · 2022-11-13 22:07:42Z

1

Could you check if the listen_addresses in the postgresql.conf accepts connections from localhost or set it to '*', if no special restriction required

answered Nov 13, 2022 at 22:07

Lusine Yakovleva

234 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

baitendbidz Over a year ago

Unfortunately I'm not able to find that file... Based on this linuxconfig.org/ubuntu-22-04-postgresql-installation it should be at /etc/postgresql/<version>/main/postgresql.conf but I can only find a postgresql-common inside etc which does not contain the file

Lusine Yakovleva Over a year ago

You can run "ps -ef|grep postgres" and look for a path following the "-D" option. The postgres.conf should be located in that directory

Collectives™ on Stack Overflow

Postgres server is running locally but refusing connection

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related