PGSQL Phriday #002 – Backups

Invitation by Andreas Scherbaum and summary post of all submissions

Your #PGSQLPhriday task

Describe how you do backups for your PostgreSQL databases.

  • Which tool(s) are you using, where do you store backups, how often do you do backups?
  • Are there any recommendations you can give the reader how to improve their backups?
  • Any lesser known features in your favorite backup tool?
  • Any new and cool features in a recently released version?

Bonus questionIs pg_dump a backup tool?