Re: pgAgent - adding parameters to runs

Hi Bastiaan Olij,

On Tue, Dec 10, 2013 at 2:55 AM, Bastiaan Olij <bastiaan(at)basenlily(dot)me>wrote:

> Hi all,
>
> I'm just throwing this out there to see if any one has had ideas about
> doing this or can suggest a workaround. It may be the final push I need
> to download the source and try my hand at extending pgAgent myself :)
>
> The situation we have is that we have multiple databases on our server
> and that we have the need to run backups for these databases
> individually. Right now we solve this by having a job for each database
> configured in pgAgent so we can run the backup script for that specific
> database.
>
> Ideally I would like to have a single job configured in pgAgent but when
> I tell the job to run, give it one or more parameters that can be
> inserted into the script text of the step(s) of the job.
> To make this work properly however storing a single parameter and
> runtime won't suffice as it is possible that I may schedule runs for
> several databases one after another each with a different setting for
> the parameter(s).
>
> The idea I had for that last issue is to add a queue table to pgAgent
> where you can queue running a job outside of the normal "next schedule"
> logic that currently exists.
>
> An alternative I've been wondering about but have no idea whether it is
> feasible is to have the pgAgent jobs stored in each individual database,
> but it would require pgAgent to log onto each database to see if there
> is a job to run in that database.
>
> Any ideas would be welcomed:)
>
>
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.

Regards,
Dinesh

> Cheers,
>
> Bastiaan Olij
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>