[FIXED] How can I solve the issue: psql cannot connect to the server in Ubuntu?

Issue

In hosting my Django web application on VPS using PostgreSQl. However, the configuration seems to be fine but whenever I want to access the Postgres Shell, I ma getting the error bellow.

root@vmi851374:~# sudo su -l postgres
        postgres@vmi851374:~$ psql
        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"?
        postgres@vmi851374:~$

I have checked the Postgres service status and everything seems fine but I don't know where this error comes from. Notice that in my localhost (laptop), I am not facing this issue. Only in the VPS server, I am getting this issue.

Please assist me to solve this issue.

Solution

I solve the problem by editing the file postgresql.conf located in /etc/postgresql/14/main/postgresql.conf Then I uncommented and edit the listen_addresses attribute to start listening to start listening to all available IP addresses: listen_addresses = '*'

In addition I edited the PostgreSQL access policy configuration file as follow:

vim /etc/postgresql/14/main/pg_hba.conf. 

Then I modified the file as follow:

host all all 0.0.0.0/0 md5

And now it is working fine. Thanks a lot @AdrianKlaver

Answered By - Mohamed Abdillah

Answer Checked By - Timothy Miller (PHPFixing Admin)