facing problem with createdb.

2009/6/29 Ms swati chande <swativc@yahoo.com>

Hi,

I built postgresql from source using Windows 2005.

Did you read
http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows?

Why not use prebuilt versions (see
http://www.postgresql.org/download/windows)?

After installation, I am trying to create a database using

createdb.

Please read these:

http://www.postgresql.org/docs/current/static/manage-ag-createdb.html
http://www.postgresql.org/docs/8.3/static/app-createdb.html

It then asks for a password. What password is it? There are now passwords
set on my system. Also tried editing pg_hba.conf. But could not solve the
problem.

How do I move ahead.

it's not clear what is wrong there, but try this:

1. Add this line to the beginning of your pg_hba.conf:
host all all 127.0.0.1/32 trust

2. restart postgresql server.

3. you should be able to connect without password.

Please post such basic questions to pgsql-general mailing list.

You should REALLY read some manual pages, especially these:
http://www.postgresql.org/docs/8.3/static/reference-client.html

good luck!

--
Filip Rembiałkowski
JID,mailto:filip.rembialkowski@gmail.com
http://filip.rembialkowski.net/