PostgreSQL: could not connect to server

When I started PostgreSQL server with specific database cluster on Ubuntu 14.04, the client coundn’t connect to the server.

# start server
postgres@ubuntu:~$ pg_ctl -D /usr/local/pgsql/data -l logfile start
# connect to the server
postgres@ubuntu:~$ psql
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"?

After I changed ‘unix_socket_directories’ in the postgresql.conf, it worked.

#unix_socket_directories = '/var/run/postgresql'        # comma-separated list of directories
unix_socket_directories = '/tmp'        # comma-separated list of directories


Leave a Reply

Your email address will not be published. Required fields are marked *