Thread: help with postgreSQL error !

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 ?

On Jun 21, 2011, at 10:19 AM, abhisheks@cse.iitb.ac.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.kumar@enterprisedb.com
Blog:http://vibhorkumar.wordpress.com