Hands-On K8s: Automate Postgres Backups with Bash & CronJobs

Name: Hands-On K8s: Automate Postgres Backups with Bash & CronJobs
Rating: 4.8 (4 reviews)

Learn to Deploy PostgreSQL on Kubernetes & Master Automated Backup/Restore using CronJobs & Bash Scripts

Created byGilbert Sam | SRE & Cloud Infrastructure

Last updated 4/2025

English

English [Auto],

What you'll learn

Learn bash scripting
Deploy applications on Kubernetes using helm
Develop cloud architectural by building a real world use case
Understand how automation works in Kubernetes using cronjobs

Course content

6 sections • 14 lectures • 51m total length

Overview of tools4:09
Learn the core tools for deploying and backing up Postgres on Kubernetes, including Docker, helm, and cronjobs, with a local Docker Desktop setup and a 30-minute backup schedule.
Architecture2:23
Describe the architecture for building a custom postgres image with backup and restore scripts, using Docker Hub, Helm, and GitHub, all on a local Kubernetes with cron jobs.
Architecture

Understanding the Postgres Helm Chart5:00
Explore how to deploy Postgres on Kubernetes using a Bitnami Helm chart, customize values.yaml, and prepare Docker images and Bash scripts for backups with cronjobs.
Understanding the Cronjob Helm Chart2:39
Learn to build a cronjob helm chart from scratch to automate Postgres backups, configure the schedule in values YAML, and assign a service account with permissions.
Create backup and restore bash scripts4:10
Create bash scripts for Postgres backup and restore, name backups by date and hour, set PG password, and save as .sh for a custom Postgres Docker setup.
Create and publish a custom Postgres docker image6:33
Build and publish a custom Postgres docker image by extending the bitnami base, adding backup and restore scripts, setting ownership and permissions, and updating the helm chart to use it.
Update your repo and push updates to GitHub3:38
Push code to a Postgres GitHub repo by creating a local repo, staging with git add, committing, and pushing, then pull for deployment on another computer, while noting password handling.
Deployments
Helm

Pull your code from GitHub1:22
Pull the code from the GitHub Postgres repo into a local git folder, clone the master branch, and verify the code is ready for deployment.
Deploy Postgres on Kubernetes7:16
deploy a Postgres instance on Kubernetes with helm, validate the installation, inspect the pod and PVCs, and examine backup and restore scripts in the custom scripts directory.
Create a table in postgres database and backup3:01
Log into a running Postgres instance, switch to the Postgres database, create an employees table with three rows, and prepare to back up the database using a cron job.
Deployment tools
Kubernetes logs

Deploy the Cronjob1:46
Deploy the cronjob to automate postgres backups, edit schedules, and validate success; update the api version to batch v1 and trigger runs every five minutes.
Kubernetes tool
Restore your backup2:07
Restore the employees table by accessing the Postgres pod and running the restore script or SQL command from a backup file, showing a solid Kubernetes cronjob backup strategy.
Kubernetes Automation

Requirements

No cloud experience is needed. You will learn everything in this course.

Description

Deploy a Postgres database server on a local Kubernetes instance and automate the database backups using Kubernetes cronjobs. Docker Desktop will be used to provision the local Kubernetes environment.

Technical details:

Set Up a Local Kubernetes Environment: Use Docker Desktop to provision a Kubernetes cluster, making cloud-native development simpler and more accessible for hands-on practice.
Hands-On DevOps for Modern Applications: Build, deploy, and manage applications on Kubernetes with GitHub, Helm, Docker, and bash scripting.
Backup and Restore Automation with Bash Scripts: Write and implement scripts to back up and restore PostgreSQL data, leveraging Kubernetes CronJobs for seamless automation.
Building & Publishing Docker Images: Learn to create custom Docker images and publish them on Docker Hub, preparing you for robust deployment processes.
Master Version Control with GitHub: Use GitHub to host application code, manage versions, and collaborate effectively across deployments.
Efficient Application Management with Helm: Manage Kubernetes applications using Helm—install, delete, and roll back versions for streamlined operations.
Introduction to PostgreSQL Essentials: Gain hands-on experience with PostgreSQL by creating tables, managing data, and navigating a PostgreSQL instance.
Using Architectural Diagrams for Technical Communication: Understand and use architectural diagrams to communicate your deployment architecture effectively.
Automate Backups with Kubernetes CronJobs: Configure a Kubernetes CronJob to automate PostgreSQL backups, simplifying maintenance and ensuring data integrity.
Essential Kubernetes Commands for Troubleshooting: Learn to view logs, identify and resolve deployment issues, and execute key commands for effective Kubernetes management.
Manual Backup Restoration: Restore PostgreSQL backups manually with a bash script, gaining a full-cycle understanding of backup and recovery.
Interactive Quizzes for Concept Reinforcement: Test your knowledge with quizzes at the end of each section to reinforce your learning.

At the end of each section you will be quizzed on the concepts which were introduced to reinforce what you learned. Ultimately, after completing this course, you would be able to architect and deploy modern applications on Kubernetes and automate various workflows.

Who this course is for:

Any tech professional who wants to build knowledge on cloud deployments.

Hands-On K8s: Automate Postgres Backups with Bash & CronJobs

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 7min

Setup tools & environment1 lecture • 4min

Prepare Helm Charts5 lectures • 22min

Deploy the Applications with Helm3 lectures • 12min

Backup and Restore2 lectures • 4min

Delete your applications1 lecture • 3min

Requirements

Description

Who this course is for: