Re: make abackup using CMD

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(at)iol(dot)ie