Wednesday, 25 May 2005

It's Alive!

Finally, after 2 weeks of frantic hacking between paid work, pgAgent is ready for testing! Anyone who follows the pgAdmin development work will already know this, however for those that don't, pgAgent is a job scheduler for PostgreSQL. Running as a service on windows and a daemon on *nix systems, it allows you to schedule jobs consisting of one or more SQL or shell/batch steps which run in sequence. Multi threading allows multiple jobs to run in parallel, and a nifty connection pooling mechanism ensures efficient resource usage on your server. Each job defined may have one or more schedules attached to it, each of which is based on an enhanced cron-style format. Management is from the pgAdmin console (of course), and the agents themselves can run on one or more machines at once.

Anyhoo, if you wanna give it a try, grab a snapshot from and schedule away! Feedback is welcome of course - please send any to