help with postgreSQL error !

Lists: pgsql-novice
From: abhisheks(at)cse(dot)iitb(dot)ac(dot)in
To: pgsql-novice(at)postgresql(dot)org
Subject: help with postgreSQL error !
Date: 2011-06-21 04:49:33
Message-ID: 6b8f5187c82270074e045215721c48d9.squirrel@www.cse.iitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice

i am getting the following error when i try to run 'createdb' command from
within the bin directory ..

/bin$ ./pg_ctl -D
/host/driveD/manualInstalls/SpatialDatabase/PostgreSQL_postGIS/installPostgreSQL/bin/UserDatabases
-l logfile start
server starting
/bin$ createdn mydb;
createdb: could not 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 "/tmp/.s.PGSQL.5432"?

pls tell me where is the problem ?


From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
To: abhisheks(at)cse(dot)iitb(dot)ac(dot)in
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: help with postgreSQL error !
Date: 2011-06-21 07:43:48
Message-ID: 8256505D-4EE1-45BB-8C2E-CDE3601D8FF0@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice


On Jun 21, 2011, at 10:19 AM, abhisheks(at)cse(dot)iitb(dot)ac(dot)in wrote:

> /bin$ ./pg_ctl -D
> /host/driveD/manualInstalls/SpatialDatabase/PostgreSQL_postGIS/installPostgreSQL/bin/UserDatabases
> -l logfile start
> server starting
> /bin$ createdn mydb;
> createdb: could not 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 "/tmp/.s.PGSQL.5432"?

Logfiles can give more information on this.
Please share the server pg_log/ and logfile information.

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhorkumar.wordpress.com