Try following command
createdb -h <hostname> -p <port_number> -U <user_name> [DBNAME]
psql -d [DBNAME] -U <user_name>
Date: Mon, 14 Mar 2011 21:39:17 -0700
From: aras_h1...@yahoo.com
Subject: [ADMIN] createdb does not work?!
To: pgsql-admin@postgresql.org
Dear Sirs,
After this command , what I should do?
Can not use createdb test command and psql test.
I installed correctly postgres by source code.
[postgres@localhost bin]$ ./postgres -D /usr/local/pgsql/data
LOG: database system was shut down at 2011-03-15 07:56:00 EDTLOG: autovacuum
launcher startedLOG: database system is ready to accept connections
