/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 vote252 views1 answer
Zsh: no such file or directory: /usr/local/bin/composer.phar
Shell/Bash
47 votes210 views6 answers
Git reset origin
Shell/Bash
1 vote216 views1 answer
Certbot list all domains
Shell/Bash
10 votes221 views2 answers
Pull master into branch
Shell/Bash
1 vote207 views2 answers
Flask restful install
Shell/Bash
0 vote221 views1 answer
Can i setup 2fa for my ubuntu ssh
Shell/Bash
13 votes222 views2 answers
Amend commit change description
Shell/Bash
0 vote165 views1 answer
How to add a character to beginning of multiple lines in vim
Shell/Bash
0 vote207 views1 answer
Get podman ubuntu
Shell/Bash
6 votes204 views1 answer
List all dependencies installed globally npm
Shell/Bash