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
rod@iol.ie