← Back to courses
Data Science and AI
PostgreSQL Backup and Restore Workshop
Two days on the backup you will one day need
A two-day classroom workshop on one chapter of the PostgreSQL 18 documentation's Server Administration part, Backup and Restore, with routine database maintenance beside it. You take a backup, lose the database on purpose, and restore it. This workshop prepares for no exam.
5Modules
IntermediateLevel
2 daysDuration
COURSE THUMBNAIL
What you will be able to do
Take a dump of a database
Restore it to a new server
Prove a backup works before you need it
Course outline
01
What can go wrong, and what a backup must cover
02
SQL dump backups
03
Restoring a dump
04
File-system-level and continuous archiving backups
05
Routine maintenance and testing your restore
Tools you will use
PostgreSQLpg_dumppsql
What you need
Basic SQL and command-line skills
