/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

12 votes232 views6 answers
Ubuntu install php 8
Shell/Bash
2 votes153 views1 answer
How to setup vim plugins
Shell/Bash
1 vote148 views1 answer
Install wine ubuntu 20.04
Shell/Bash
0 vote144 views1 answer
Microstack change horizon port
Shell/Bash
2 votes129 views2 answers
Npm postgres
Shell/Bash
0 vote157 views1 answer
Start-stop-daemon force kill sigkill
Shell/Bash
0 vote205 views1 answer
How to push to a new repositiory in github
Shell/Bash
0 vote158 views1 answer
Node-gyp rebuild
Shell/Bash
0 vote261 views1 answer
Webgl server apache
Shell/Bash
0 vote138 views1 answer
How to download fl studio on linux
Shell/Bash