Thread: PG_DUMp

<br /><font face="sans-serif" size="2">Hi all,</font><br /><br /><font face="sans-serif" size="2">You know how i can
makea backup of database automatically? I have a script "pg_dump.exe DBNAME -U USER  > FILE" but i don't know how
putthe password. If i put "-W password" the command line say that i put more paramatrers that the program
accept.</font><br/><br /><font face="sans-serif" size="2">Best Regards</font><br /><br /> 

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