Re: Postgresql Database cant start after restore using pgBackRest

Поиск
Список
Период
Сортировка
От David Steele
Тема Re: Postgresql Database cant start after restore using pgBackRest
Дата
Msg-id 634ceaf1-abb1-8bcc-f7a4-bb407f468a25@pgmasters.net
обсуждение исходный текст
Ответ на Re: Postgresql Database cant start after restore using pgBackRest  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-admin
On 6/27/23 12:12, Ron wrote:
> On 6/27/23 03:26, David Steele wrote:
>> On 6/27/23 07:41, Deo Felix wrote:
>>> In the postgresql.auto.conf i have this configs
>>> restore_command = 'pgbackrest --pg1-path=/var/lib/postgres/main 
>>> --stanza=data archive-get %f "%p"'
>>> recovery_target = 'immediate'
>>> recovery_target_timeline = 'current'
>>>
>>> But still I the database cant start
>>
>> You will need to redo your pgbackrest restore with 
>> --target-timeline=current and then restart postgres to start recovery 
>> with the correct settings.
> 
> Is this standard procedure for an "in place" --delta restore?

No -- this is mitigation for the split-brain situation which was causing 
the OP's recovery error.

Regards,
-David



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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Why log_statement may not work for a particular database?
Следующее
От: Deo Felix
Дата:
Сообщение: Re: Postgresql Database cant start after restore using pgBackRest