Re: automating backups with windows scheduled tasks and pg_dumpall - Mailing list pgsql-general

From Tom Hart
Subject Re: automating backups with windows scheduled tasks and pg_dumpall
Date
Msg-id 473CDB3A.3060705@coopfed.org
Whole thread Raw
In response to Re: automating backups with windows scheduled tasks and pg_dumpall  ("Martin Gainty" <mgainty@hotmail.com>)
List pgsql-general
Martin Gainty wrote:
> Hi Tom
>
> In windows you would need to include the runas command so your bat file
> needs to execute the command via runas as in
> runas /user:postgres "bin\pg_dumpall.exe -U foo_postgres"
>
> HTH
> Martin
Actually, schtasks.exe and the windows task scheduler both have this
functionality built in. Also, when using runas.exe from a command
prompt, there's no way to give it a password, thus rendering it
incapable of running unattended in a scheduled task setup. I believe
that's why they placed the runas functionality into schtasks.exe
actually. Thanks anyway.

Thomas R. Hart II
tomhart@coopfed.org

pgsql-general by date:

Previous
From: "Martin Gainty"
Date:
Subject: Re: automating backups with windows scheduled tasks and pg_dumpall
Next
From: "Trevor Talbot"
Date:
Subject: Re: Postgresql and resource isolation