PGSQL Phriday #002: PostgreSQL Backup and Restore

From: Andreas 'ads' Scherbaum <ads(at)pgug(dot)de>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: PGSQL Phriday #002: PostgreSQL Backup and Restore
Date: 2022-10-31 14:22:25
Message-ID: ff5a8509-ac44-6cbb-7519-c180ea2ef4eb@pgug.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2022-10-31 16:22:34 Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should
Previous Message Erika Knihti-Van Driessche 2022-10-31 14:18:23 Alfresco and postgres schemas