Scheduled PostgreSQL jobs with AWS Batch
Peter is currently a Consultant at AWS ProServe. He is a sysadmin and PostgreSQL database administrator, specializing in DevOps and monitoring solutions.
No video of the event yet, sorry!
Since before PostgreSQL existed, CRON has been the standard daemon for scheduling nearly any task in the Linux ecosystem. With the rise of cloud computing and managed database instances, job scheduling has gotten slightly more complicated then running a simple PSQL script on our database server, and connecting through a Unix socket. While the simplest methods of running scheduled database jobs are a less viable option, we have a variety of options to keep our scheduled jobs running on-time.
Let's dive into one such replacement for CRON, AWS Batch. We'll be going over some best practices with AWS Batch, exploring automation around AWS Batch which might make life easier, and reviewing it's usage as a job scheduler for PostgreSQL.
- 50 min
- Postgres Conference 2020
- Ops and Administration