put automatically password of user in pg_restore command line windows

Question

I want to restore my database postgres using pg_restore in command line and i want to put the password of user directly in the command, I tried this command but doesn't work

pg_restore -h localhost -p 5432 -U postgres -W 123 -d my_db my_backup.backup

but the following message is displayed

pg_restore: too many arguments on the command line (the first being "-d")

mike.k · Answer 1 · 2018-06-21T18:50:00.277

18

Set the password as an environment variable: set "PGPASSWORD=123" You can set other arguments this way as well: https://www.postgresql.org/docs/current/static/libpq-envars.html

-W is to force a password prompt, not to supply a password directly, thats why it says there are too many arguments.

Putting it all together:

set "PGPASSWORD=123"
pg_restore -h localhost -p 5432 -U postgres -d my_db my_backup.backup

Update: Thanks @aschipfl, I initially had incorrect quoting on set

edited Jun 21 '18 at 18:50

answered Jun 21 '18 at 15:17

mike.k

3,277
1
12
18

1

The question didn't ask for it, but using a password file is more secure. – Laurenz Albe Jun 21 '18 at 15:34
2

When using `set PGPASSWORD="123"`, the quotes are part of the variable value; write `set "PGPASSWORD=123"` instead to avoid that... – aschipfl Jun 21 '18 at 16:54
If you need to run this from a script you need to export the environment variable. `export PGPASSWORD='123'` – Libert Mar 18 '22 at 13:46
-bash: 123: event not found – reza_khalafi Jul 03 '22 at 08:18

put automatically password of user in pg_restore command line windows

1 Answers1