Re: Can we run pg_basebackup master is still working normally(selects, updates, deleted, etc)

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Can we run pg_basebackup master is still working normally(selects, updates, deleted, etc)
Дата
Msg-id 6e9764f7-f6d1-0597-ecf7-c78d66d84007@2ndquadrant.com
обсуждение исходный текст
Ответ на Can we run pg_basebackup master is still working normally (selects,updates, deleted, etc)  (Adrian Heath <adrian.heath@tracktrans.com>)
Ответы Re: Can we run pg_basebackup master is still working normally(selects, updates, deleted, etc)  (Adrian Heath <adrian.heath@tracktrans.com>)
Список pgsql-general
On 5/4/18 06:41, Adrian Heath wrote:
> The system is used 24/7. Can we run pg_basebackup while the master is 
> still receiving updates without worrying about physical file corruptions 
> in the generated archive file?

Yes, as long as you follow the instructions about saving the WAL
generated during the backup and replaying it on the newly created standby.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Adrian Heath
Дата:
Сообщение: Can we run pg_basebackup master is still working normally (selects,updates, deleted, etc)
Следующее
От: nikhil raj
Дата:
Сообщение: How to find the hits on the databases and tables in Postgres