Re: pgAgent - adding parameters to runs

Hi Dinesh,

On 10/12/13 5:26 PM, Dinesh Kumar wrote:
>
> Does it
> <http://manojadinesh.blogspot.in/2012/10/windows-pgdump-script.html>
> work for you. Make this script as a single job to the pgAgent.
We already use that approach but it would still require us to configure
a job for each database that calls the batch file with the database name
as a parameter (which is how we are doing things today).

As we regularly add new databases and remove ones we no longer need that
gives us a lot of overhead in maintaining the pgAgent jobs with a high
risk of typos sneaking in when we do so.

None of these jobs are scheduled, we have a nightly backup script that
backs up all databases with one script that detects which databases
exist. These jobs are for incidental backups such as ones we run on an
individual database before performing schema changes or certain
processes where we need to be able to go back to backup if things go wrong.

Cheers,

Bas