PG_DUMp

Started by Nonameover 20 years ago2 messages
#1Noname
esolsona@wurth.es

Hi all,

You know how i can make a backup of database automatically? I have a
script "pg_dump.exe DBNAME -U USER > FILE" but i don't know how put the
password. If i put "-W password" the command line say that i put more
paramatrers that the program accept.

Best Regards

#2Andrew Dunstan
andrew@dunslane.net
In reply to: Noname (#1)
Re: PG_DUMp

esolsona@wurth.es wrote:

Hi all,

You know how i can make a backup of database automatically? I have a
script "pg_dump.exe DBNAME -U USER > FILE" but i don't know how put
the password. If i put "-W password" the command line say that i put
more paramatrers that the program accept.

You have asked this question on the wrong list - please ask questions
like this on the pgsql-general list.

If you look up the documentation on how to use a pgpass file you should
discover an answer to your question.

cheers

andrew