/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 vote298 views1 answer
Remove home partition centos 6
Shell/Bash
0 vote301 views1 answer
Tar –exclude directories from a File
Shell/Bash
0 vote274 views1 answer
Could not install packages due to an EnvironmentError: [WinError 32] The process cannot access the file because it is being used by another process
Shell/Bash
0 vote296 views1 answer
Ignore Composer Platform Request
Shell/Bash
1 vote315 views5 answers
/usr/bin/env: ‘bash\r’: No such file or directory
Shell/Bash
3 votes275 views2 answers
Checkout remote file different name
Shell/Bash
0 vote281 views2 answers
Vbs on linux
Shell/Bash
17 votes303 views1 answer
Install openjdk 8 sdk on ubuntu
Shell/Bash
31 votes298 views6 answers
Get all remote branches
Shell/Bash
0 vote276 views1 answer
Install rpm package
Shell/Bash