I am running Ubuntu 16. I have installed Postgresql. Postgresql used to work, but then I rebooted.
nmap commands show port 5432 is open. Postgres seems to be working correctly:
service postgresql status
postgresql.service - PostgreSQL RDBMS Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled) Active: active (exited) since Sat 2017-07-29 18:42:59 EDT; 1min 4s ago Process: 201 ExecStart=/bin/true (code=exited, status=0/SUCCESS) Main PID: 201 (code=exited, status=0/SUCCESS)
Memory: 0B CGroup: /system.slice/postgresql.service
I ran this: psql
But I got this:
psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
The file listed above does not seem to exist.
How do I get into Postgresql? Normally I'd run psql
or sudo -i -u postgres
then psql
. But these commands are not working. I keep getting an error about "could not connect to server." Several reboots have not helped.
Update:
I ran this command: dpkg -l | grep postgres
rc postgresql-9.5 9.5.6-0ubuntu0.16.04 amd64 object-relational SQL database, version 9.5 server ii postgresql-client 9.5+173 all front-end programs for PostgreSQL (supported version) ii postgresql-client-9.5 9.5.7-0ubuntu0.16.04 amd64 front-end programs for PostgreSQL 9.5 ii postgresql-client-common 173 all manager for multiple PostgreSQL client versions ii postgresql-common 173 all PostgreSQL database-cluster manager
ps aux | grep '[b]in/postgres'
?pg_lsclusters
, please. Also try usingpsql -h 127.0.0.1
. It may be a configuration issue (disabled Unix sockets).postgresql-9.5
shoud beii
, notrc
, which means it has been uninstalled. The configuration files and data should still be there, so simply doingapt-get install postgresql-9.5
has a good chance to work.service postgresql status
is useless since the switch tosystemd
. Apparently it can reportactive
when the service is actually down, probably depending on the reason why it's down.