Re: Simulate a PITR in postgresql 16

Поиск
Список
Период
Сортировка
От Christoph Moench-Tegeder
Тема Re: Simulate a PITR in postgresql 16
Дата
Msg-id aGL7o4j8hx7ZtEh9@elch.exwg.net
обсуждение исходный текст
Ответ на Simulate a PITR in postgresql 16  (Franklin Anderson de Oliveira Souza <franklinbr@gmail.com>)
Список pgsql-general
## Franklin Anderson de Oliveira Souza (franklinbr@gmail.com):

> LOG: database system was shut down at 2025-06-30 12:15:28 -04
> cp: cannot stat '/dados/temp/wals/00000002.history': No such file or directory
> -----------------
> 
> 
> The restore_command requires the .history file but it does not exist
> in any of the clusters in this simple test, which is wrong in this
> example ? Tanks

Everything is fine - as long as the next log line starts with "starting
backup recovery". Your cluster starts on timeline 1, and the (default)
recovery_target_timeline is "latest", so the recovery process needs
to check if other timelines exist and what the latest timeline is.
It's just that the stderr from cp ends up in your log.
See
https://www.postgresql.org/docs/17/continuous-archiving.html#BACKUP-TIMELINES
for details on timelines.

Regards,
Christoph

-- 
Spare Space



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