/Shell/Bash/Could not connect to server: Connection refused Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432

Could not connect to server: Connection refused Is the server running on host "localhost" (::1) 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

Could not connect to server: Connection refused Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432

// In my case PostgreSQL updates from version 13.4 to 14 in background, so it fixes by:
	brew postgresql-upgrade-database
// In other case the problem fixed by:
	rm -rf /usr/local/var/postgres/postmaster.pid
// Restart service postgresql:
	brew services restart postgresql
// How can you understand what is the problem?
// For first see what service is not correct started:
	brew services list
// For second show file postgres.log, where will be the error:
	tail -f /usr/local/var/log/postgres.log
// And so find answer by this error's text

Similar codes

18 votes205 views1 answer
Check full memory details
Shell/Bash
0 vote638 views1 answer
Warning: Homebrew's sbin was not found in your PATH but you have installed formulae that put executables in /usr/local/sbin.
Shell/Bash
14 votes209 views6 answers
Git push origin master
Shell/Bash
0 vote207 views1 answer
How to install cmake ninja
Shell/Bash
0 vote201 views1 answer
How to move from one to another drive in powershell
Shell/Bash
0 vote212 views1 answer
Site:github.com speedtest web app
Shell/Bash
0 vote231 views2 answers
Uninstall django ubuntu
Shell/Bash
0 vote206 views1 answer
Git link local branch to remote branch
Shell/Bash
12 votes250 views3 answers
How uninstall laravle package
Shell/Bash
0 vote212 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