Re: [pgadmin-support] make abackup using CMD

2013-02-09 Thread David Blaymires
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

Re: [pgadmin-support] make abackup using CMD

2013-02-09 Thread Raymond O'Donnell
On 09/02/2013 16:13, Ahmed Mohammed Darwish 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

[pgadmin-support] make abackup using CMD

2013-02-09 Thread Ahmed Mohammed Darwish
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 paramete