Re: Does pg_start_backup changes how Postgres writes data?

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Does pg_start_backup changes how Postgres writes data?
Дата
Msg-id 20190708145226.GZ29202@tamriel.snowman.net
обсуждение исходный текст
Ответ на Does pg_start_backup changes how Postgres writes data?  (Thorsten Schöning <tschoening@am-soft.de>)
Список pgsql-admin
Greetings,

* Thorsten Schöning (tschoening@am-soft.de) wrote:
> From what I understand from reading the docs and multiple other
> sources, I have a different opinion: The only thing pg_start_backup
> changes regarding writes in the data directory of Postgres is that a
> checkpoint is done as part of starting the backup, even if no
> checkpoint would be needed currently otherwise. After that is done,

Magnus' already replied to most of this, but I wanted to point out that
you can control if pg_start_backup forces an immediate checkpoint or if
it waits for the checkpoint to complete naturally.

Thanks,

Stephen

Вложения

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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: When it's really necessary to enable WAR archiving in case oflow level backups?
Следующее
От: Thorsten Schöning
Дата:
Сообщение: Does anyone backup directly on Synology NAS using Barman or similar?