Re: pg_basebackup / recovery

Поиск
Список
Период
Сортировка
От Achilleas Mantzios - cloud
Тема Re: pg_basebackup / recovery
Дата
Msg-id 9f9aaa96-cd32-bbb9-ba15-d8685c9aeb08@cloud.gatewaynet.com
обсуждение исходный текст
Ответ на pg_basebackup / recovery  (Fabrice Chapuis <fabrice636861@gmail.com>)
Ответы Re: pg_basebackup / recovery  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-general

On 4/12/23 12:32, Fabrice Chapuis wrote:

During recovery process of a self contained backup, how postgres know to stop reading wal when consistency is reached?


Because it knows the full packup info. It will observe the

STOP WAL LOCATION: 3BC7/4B000130 (file 0000000200003BC70000004B)

inside the backup file

 It's a full contained backup because you haven't called with the -X method none , and it doesn't get into standby because you haven't called with --write-recovery-conf !

I believe by default it will do what you meant that you want.

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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: parallel aggregation
Следующее
От: John Howroyd
Дата:
Сообщение: Re: Guidance on INSERT RETURNING order