/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

0 vote272 views1 answer
Bash command help
Shell/Bash
0 vote281 views1 answer
Install npm packages on shared hosting
Shell/Bash
2 votes263 views2 answers
Remove blender ubuntu 20.04
Shell/Bash
1 vote319 views1 answer
Clear
Shell/Bash
0 vote298 views2 answers
Terminals for ubuntu 20.04
Shell/Bash
0 vote273 views1 answer
How to check if cyberduck is installed
Shell/Bash
56 votes278 views1 answer
How to change a user email for a project in git
Shell/Bash
0 vote269 views1 answer
Install react select
Shell/Bash
0 vote313 views1 answer
Install vim in alpine
Shell/Bash
0 vote275 views2 answers
How to edit etc/hosts linux error readonly e45
Shell/Bash