PGSQL Phriday #002: PostgreSQL Backup and Restore

Поиск
Список
Период
Сортировка
От Andreas 'ads' Scherbaum
Тема PGSQL Phriday #002: PostgreSQL Backup and Restore
Дата
Msg-id ff5a8509-ac44-6cbb-7519-c180ea2ef4eb@pgug.de
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Erika Knihti-Van Driessche
Дата:
Сообщение: Alfresco and postgres schemas
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should