Stado

Can't connect to stado server via psql

Asked by Xiaobo Gu

Hi,

I have set up a demo cluster with-in a single server environment, and the gs-cmdline.sh -d xtest -u admin -p secret works,

But psql can't work

[stado@lix bin]$ psql -p 6453 -U admin xtest
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.6453"?

I am running PostgreSQL 9.3 beta2 building from source, is this a problem.

Question information

Language:
English Edit question
Status:
Solved
For:
Stado Edit question
Assignee:
No assignee Edit question
Solved by:
Alvin Peng
Solved:
Last query:
Last reply:
Revision history for this message
Best Alvin Peng (pengalvin) said : 		#1

You need to add the ip information, like:

[stado@lix bin]$ psql -h <server_ip> -p 6453 -U admin xtest

Revision history for this message
Xiaobo Gu (guxiaobo1982) said : 		#2

Thanks Alvin Peng, that solved my question.