On Thu, Nov 10, 2011 at 1:24 PM, daflmx
<daflmx@qq.com> wrote:
Hello,all.
I have installed the postgresql .
$/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
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
To start/stop use pg_ctl utility which has good options.
Eg:-
$/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data start
$/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop
but when I want to connect to the server at another terminal
$/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"?
I don't think you are trying to connect to the database, however you are creating the database in a cluster.
For connection you need to use below command:-
Eg:-
$/usr/local/pgsql/bin/psql -U postgres -p 5432 -d postgres
$/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
FATAL:lock file "postmaster.pid"already exists
HINT: Is another postmaster(PID 1950)running in data directory "/usr/local/pgsql/data"?
This tell you cluster is already up and running and ready to accept connections.
You can know the status of cluster whether running or not by below command.
Eg:-
$/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data status.
---