Обсуждение: PGSQL Phriday #002: PostgreSQL Backup and Restore

Hello,

The topic for the second #PGSQLPhriday is: PostgreSQL Backup and Restore


Your 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 question: Is pg_dump a backup tool?


More details and information how to participate can be found here:
https://andreas.scherbaum.la/blog/archives/1122-PGSQL-Phriday-002-PostgreSQL-Backup-and-Restore.html


Looking forward to your blog posts!

-- 				Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project