Thread:
Hello,all.
I have installed the postgresql .
$/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data start
LOG:database system was shut down at 2011-11-10 15:36:14 CST
LOG:database system is ready to accept connections
LOG:autovacuum launcher started
when I check the status of cluster
$/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data status
pg_ctl:server is running(PID 18432)
but why I cannot create a database successfully?
$/usr/local/pgsql/bin/createdb mydb
createdb:could nto connect to database postgres: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"?
and I did not find the ".s.PGSQL.5432" file in the whole file system.what's the wrong?
Thanks.
You have sent this message at least once before.
Pleas go back and read the replies to the first one, don't just re-send your message.
On 11/11/2011 11:36 AM, daflmx wrote:
Pleas go back and read the replies to the first one, don't just re-send your message.
On 11/11/2011 11:36 AM, daflmx wrote:
Hello,all.I have installed the postgresql .$/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data startLOG:database system was shut down at 2011-11-10 15:36:14 CSTLOG:database system is ready to accept connectionsLOG:autovacuum launcher startedwhen I check the status of cluster$/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data statuspg_ctl:server is running(PID 18432)but why I cannot create a database successfully?$/usr/local/pgsql/bin/createdb mydbcreatedb:could nto connect to database postgres:could not connect to server:No such file or directoryIs the server running locally and accepting connections on Unix domain socket"/var/run/postgresql/.s.PGSQL.5432"?and I did not find the ".s.PGSQL.5432" file in the whole file system.what's the wrong?Thanks.