PGSQL Phriday #002: PostgreSQL Backup and Restore - Mailing list pgsql-general

From Andreas 'ads' Scherbaum
Subject PGSQL Phriday #002: PostgreSQL Backup and Restore
Date
Msg-id ff5a8509-ac44-6cbb-7519-c180ea2ef4eb@pgug.de
Whole thread Raw
List pgsql-general

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

pgsql-general by date:

Previous
From: Erika Knihti-Van Driessche
Date:
Subject: Alfresco and postgres schemas
Next
From: Adrian Klaver
Date:
Subject: Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should