Error while running createdb from a batch file in windows xp

[anand4nk]

Hi,

I am installing postgreSQL 8.2 using batch files in windows xp machine.

I am installing postgres using postgresql-8.2.msi installer.
Installation was successful.

When i tried to run createdb command
using the following command from another batch file
"createdb -U dbname username"

command prompt asked me to enter password for the username

Is there a way to avoid this password prompt.

This command works good in windows 2000

Thanks in Advance,
Anand

[michaelb]

Unless you set up your database access with the "trust" option this prompt is probably asking for your password, not the password for the username you passing to the createdb command.

Look at pg_hba.conf file, or simply run something like psql -l - would you be prompted for password?

If this is the case you can either change your access mode to trust instead of password, or put something like this in your batch file:
set PGPASSWORD=my_password

Obviously you may need to consider the possible security issues arising from these actions.

[michaelb]

And by the way, the code snippet for createdb command you posted is incorrect:
>> createdb -U dbname username
The correct format is
createdb -U username dbname
so make sure you call it correctly. Try "createdb --help" for more info.

[anand4nk]

Thanks Michael.

You guessed it right.

I changed the line in pg_hba.conf file from

host all all 127.0.0.1/32 md5
to
host all all 127.0.0.1/32 trust

and the problem got solved.

Sorry for the mistake i made in createdb syntax.
My batch file syntax was right. I quoted wrong to the forum.

Once again, Thank you very much...

[michaelb]

No problem, you're very welcome!

[kenatsun]

I'm pleased to confirm that the solution of adding

set PGPASSWORD=my_password

to your .bat file works fine, too. Thanks for the tip!

~ Ken