Use a .pgpass file. Specifically, you are nominating Postgres as the user so there needs to be a .pgpass file in the Postgres user's home folder. So on more recent versions, in /Users/postgres/AppData/Roaming/Postgres/. Note: the databases in the pgpass file must be set to * otherwise you won't have the rights to back up all the databases.
If you are doing this o n a regular basis, or want this to happen automatically each day then you should look at pgAgent and set up jobs in that. It works very well.
Regards
David Blaymires
Sent from my iPad
Dears,
I need a help for the following case:
I want to make auto backup for the database using Dos Command line , I made the following CMD line
pg-dumpall -h localhost -Upostgres > allinone.bak
but I found every time I have to enter password. So , how can I include the password parameter in the above statement so that I can schedule this patch to take a backup 4 times daily without entering the password every time.
Thank you in advance for your support.
This electronic communication is intended by the sender only for the access and use by the addressee and may contain confidential information. It is your responsibility to ensure this e-mail and any attachments are virus free. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. National Air Services (NAS Holding) is a Closed Joint Stock Company, organized under the laws of the Kingdom of Saudi Arabia, having its mailing address as P.O. Box 305161 Riyadh 11361 KSA