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 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.
You can't include the password on the command line; you can instead use an environment variable[1] or a .pgpass file[2]. HTH, Ray. [1] http://www.postgresql.org/docs/9.2/static/libpq-envars.html [2] http://www.postgresql.org/docs/9.2/static/libpq-pgpass.html -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
