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 on 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 On 10/02/2013, at 3:25 AM, "Ahmed Mohammed Darwish" <adarw...@nasaviation.com> wrote: > 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
