Lists: | pgsql-hackers |
---|
From: | esolsona(at)wurth(dot)es |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | PG_DUMp |
Date: | 2005-08-30 11:45:29 |
Message-ID: | OFC98D9DCD.FE6D198C-ONC125706D.004092E2-C125706D.0040653C@wurth.es |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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
From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | esolsona(at)wurth(dot)es |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: PG_DUMp |
Date: | 2005-08-30 12:25:01 |
Message-ID: | 4314501D.7010506@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
esolsona(at)wurth(dot)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