Re: hot standby in Postgresql 12

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: hot standby in Postgresql 12
Дата
Msg-id CAKFQuwZ8_+zpBo7sZCkN5VKSB8n0tehgZXnbrd514j8RQ6EdNA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: hot standby in Postgresql 12  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: hot standby in Postgresql 12
Список pgsql-admin
On Tuesday, January 19, 2021, Laurenz Albe <laurenz.albe@cybertec.at> wrote:

> > cp: cannot stat '/u01/archive/000000030000000000000035': No such file or directory
> > 2021-01-18 07:31:01.043 UTC   [21079]LOG:  started streaming WAL from primary at 0/35000000 on timeline 3
> >
>
> And now the standby is waiting for the next wal file to be archived by the primary.
> You should probably set archive_timeout to a non-zero value since the primary doesn’t
>  seem very busy (though you also still need to do at least one write, empty wal files
>  don’t get rotated out and archived.)

If the standby is *streaming* WAL, it is *not* waiting for a WAL segment to be archived.
WAL is streamed to the standby right away.

I took the error from the cp command to mean that this was in fact a warm standby regardless of any claims by the poster.  I’ll readily admit I am not that familiar with this stuff though.

David J.
 

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

Предыдущее
От: Graham Everton
Дата:
Сообщение: Re: Table Partitioning
Следующее
От: Amit jain
Дата:
Сообщение: Re: Table Partitioning