pgAgent Stumbling Blocks

In addition to doing scheduled backups from Postgres, we’ve also needed to load nightly dumps sent via scp to our database server’s filesystem.  I finally got pgAgent working, but it wasn’t without much consternation.  If you need to do this sort of thing on Windows, I’d recommend using Task Scheduler and a batch file if pgdump…