Mid SQL

PostgreSQL:?

  • Use cron jobs to automate pg_dump commands.

Example (Linux):

0 3 * * * pg_dump -U postgres mydatabase >

/path/to/backup/mydatabase_$(date +\%Y\%m\%d).sql

  • Use pgBackRest or Barman for more advanced backup automation.

More from SQL Server Tutorial

All questions for this course