/Shell/Bash/Could not connect to server: Connection refused Is the server running on host and accepting TCP/IP connections on port 5432?

Could not connect to server: Connection refused Is the server running on host and accepting TCP/IP connections on port 5432?

cd /etc/postgresql/9.x/main/
------- open file named postgresql.conf
sudo nano postgresql.conf
------- add this line to that file
listen_addresses = '*'
------- then open file named pg_hba.conf
sudo nano pg_hba.conf
------- and add this line to that file
host  all  all 0.0.0.0/0 md5
------- restart your server
sudo /etc/init.d/postgresql restart

Source: stackoverflow.com

Similar codes

1 vote236 views1 answer
Package "ngx-mask" has an incompatible peer dependency to "@angular/common"
Shell/Bash
-1 vote241 views1 answer
Debian 10 sources
Shell/Bash
5 votes243 views2 answers
Chmod executable
Shell/Bash
0 vote232 views1 answer
Install realsense viewer in jetson nano
Shell/Bash
3 votes237 views2 answers
Get database url heroku
Shell/Bash
0 vote266 views1 answer
How to install etcher on centos 7
Shell/Bash
33 votes247 views6 answers
Install jupyter
Shell/Bash
1 vote243 views1 answer
Instal screen di linux
Shell/Bash
0 vote264 views1 answer
Uninstall lubuntu
Shell/Bash
1 vote274 views1 answer
Keep docker container running
Shell/Bash