Question
CentOS / No Longer able to access PostgreSQL
This morning, all the sites were down and I tried to ssh into the server. After failing to log in, I accessed the server through the DO Console and saw a memory overflow error which apparently led to a segfault. I felt I had no choice but to roll back to a prior snapshot. I rebooted PostgreSQL, but I kept getting something like the following:
shutdown [FAIL]
start {OK}
After each Postgres reboot, I get the same as above. When I check to see if Postgres is running, it shows that it is running.
I switched to the postgres user, and $psql and threw this error:
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
I added the localhost path to the /.bash_config
and now I have error about not being able to access with the following errors:
psql: could not connect to server: Connection refused
Is the server running on host [local IP adress] and accepting
TCP/IP connections on port 5432?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×