Re:

[Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx>]

On Thu, Nov 10, 2011 at 1:24 PM, daflmx <daflmx@xxxxxx> 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 

http://www.postgresql.org/docs/9.1/static/app-pg-ctl.html

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

 

http://www.postgresql.org/docs/9.1/static/app-psql.html

$/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.

---

Regards,

Raghavendra

EnterpriseDB Corporation

Blog: http://raghavt.blogspot.com/