Re: Hot backup in PostgreSQL

Поиск
Список
Период
Сортировка
От Adam Brusselback
Тема Re: Hot backup in PostgreSQL
Дата
Msg-id CAMjNa7eJZaeNewGq6YwVN=qon87hLiHqJgvQQUZ8B5L4=_0jYw@mail.gmail.com
обсуждение исходный текст
Ответ на Hot backup in PostgreSQL  ("W.P." <laurentp@wp.pl>)
Ответы Re: Hot backup in PostgreSQL  (Mark Johnson <remi9898@gmail.com>)
Список pgsql-general
> how to do "hot backup" (copying files) while database running?
As others have shown, there are ways to do this with PG's internal tooling (pg_basebackup).

However, I would highly recommend you use an external backup tool like pgbackrest [1] to save yourself the pain of implementing things incorrectly and ending up with non-viable backups when you need them most. I'm not affiliated with them at all, but have just used pgbackrest in production for years now with great results.  It takes care of PITR, and manages backup retention (and associated WAL retention). Those can be a bit of a pain to do manually otherwise.

Just my $0.02, hope it helps!

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Initplan placed at the righttree or the lefttree of joinnode
Следующее
От: Ayub M
Дата:
Сообщение: postgres materialized view refresh performance