How to hardcode password in batch file

Question

I am creating a batch file that will automatically run the following commands:

SET PATH=%PATH%;C:\Program Files\PostgreSQL\9.0\bin
initdb -D "data" -U USERNAME –E UTF-8
pg_ctl -D "data" -l logfile start
createdb -E UTF-8 -e -O USERNAME -U USERNAME -w sampledb

When I get to this point, it prompts for a password -- is there a way I can hardcode this password in, so I don't have to manually enter it in?

Thanks! Any insight would be appreciated.

if you simply type 'createdb' does it show you the flags that you can pass in? I know in mysql you can pass a -p'password' without the ' and it will do the password for you. — Jared
– Jared, Commented Nov 16, 2011 at 19:32

Silas Parker · Accepted Answer · 2011-11-18 09:12:30Z

3

You can specify PGPASSWORD as an environment variable for many commands, e.g:

PGPASSWORD=foo pg_...

answered Nov 18, 2011 at 9:12

Silas Parker

8,1771 gold badge32 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to hardcode password in batch file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related