Re: How to start slave after pg_basebackup. Why min_wal_size andwal_keep_segments are duplicated

Поиск
Список
Период
Сортировка
От Paul Förster
Тема Re: How to start slave after pg_basebackup. Why min_wal_size andwal_keep_segments are duplicated
Дата
Msg-id B7E0C7C6-865B-4632-B10A-11B2E468D40A@gmail.com
обсуждение исходный текст
Ответ на How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated  ("Andrus" <kobruleht2@hot.ee>)
Ответы Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
Список pgsql-general
Hi Andrus,

> On 31. May, 2020, at 21:47, Andrus <kobruleht2@hot.ee> wrote:
> replikaator@[unknown] ERROR:  requested WAL segment 00000001000002CF000000E9 has already been removed

the message says it all. You need to copy the WAL file 00000001000002CF000000E9 and newer to the replica's pg_wal
directorybecause it has been removed already on the master site. Obviously, you can only do that if the files have been
archived.Otherwise, you'd have to fully reinitiate the replica. 

Replication will start again as soon as the requested WALs are copied over to the replica.

Use a replication slot to avoid this situation. If you use a replication slot, the master will only remove WAL files
whichare not needed by any one replica. 

Hope this helps.

Cheers,
Paul


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: How to start slave after pg_basebackup. Why min_wal_size andwal_keep_segments are duplicated
Следующее
От: tony@exquisiteimages.com
Дата:
Сообщение: Re: pg_dump of database with numerous objects