PostgreSQL Backup, Restore and Recovery

/ home / computer / postgresql / postgresql-for-mysql-admins / .

Logical Backup

• mysqldump

Physical Backup

• xtrabackup

Backup methods

• File system copy
• Dump
• Snapshots
• PostgreSQL physical backup

Point-in-Time-Recovery

• The Write-Ahead-Log (WAL)
• Managing the WAL
• Doing a PiTR

• mysqlbinlog

• binary log

Testing your restore!