Lists: | pgsql-general |
---|
From: | daflmx <daflmx(at)qq(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | |
Date: | 2011-11-10 09:04:10 |
Message-ID: | tencent_3D534C122F5382153924754B@qq.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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"?
Thanks.
From: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
---|---|
To: | daflmx <daflmx(at)qq(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: |
Date: | 2011-11-11 00:17:10 |
Message-ID: | 4EBC6986.20506@ringerc.id.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On 11/10/2011 05:04 PM, daflmx wrote:
>
> Is the server running locally and accepting connections on Unix domain
> socket"/var/run/postgresql/.s.PGSQL.5432"?
Well?
Does the socket file exist?
Is PostgreSQL configured to use a different socket - perhaps in /tmp -
in postgresql.conf?
I'm guessing you're using `psql' from your OS's packages, which expects
to find the PostgreSQL socket in /var/run/postgresql/ , but a PostgreSQL
server you installed yourself that puts its socket in /tmp or somewhere
else.
Note that you should still be able to connect with `-H localhost' to use
TCP/IP rather than unix domain sockets.
--
Craig Ringer