How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated

Поиск
Список
Период
Сортировка
От Andrus
Тема How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
Дата
Msg-id 26EC9619620649D1B55C9C95811E4ADB@dell2
обсуждение исходный текст
Ответы Re: How to start slave after pg_basebackup. Why min_wal_size andwal_keep_segments are duplicated  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: How to start slave after pg_basebackup. Why min_wal_size andwal_keep_segments are duplicated  (Paul Förster <paul.foerster@gmail.com>)
Список pgsql-general
Hi!

pg_basebackup takes 8 hours.
After it is finished,  replication slave does not start:

LOG:  consistent recovery state reached at 2DE/985A5BE0
LOG:  database system is ready to accept read only connections
LOG:  started streaming WAL from primary at 2DE/99000000 on timeline 1
replikaator@[unknown] LOG:  received replication command: SHOW data_directory_mode
replikaator@[unknown] LOG:  received replication command: IDENTIFY_SYSTEM
replikaator@[unknown] LOG:  received replication command: START_REPLICATION 2CF/E9000000 TIMELIN
replikaator@[unknown] ERROR:  requested WAL segment 00000001000002CF000000E9 has already been re
replikaator@[unknown] LOG:  received replication command: SHOW data_directory_mode
replikaator@[unknown] LOG:  received replication command: IDENTIFY_SYSTEM
replikaator@[unknown] LOG:  received replication command: START_REPLICATION 2CF/E9000000 TIMELIN
replikaator@[unknown] ERROR:  requested WAL segment 00000001000002CF000000E9 has already been removed
...

i tried it again and same error occured.

How to force replication to start?

I increased wal parameters in master to

wal_compression=on
max_wal_size = 5GB
min_wal_size = 4GB # was 80MB
wal_keep_segments= 360 # was 180

Will this allow replication to start after pg_basebackup ?

According to doc min_wal_size and wal_keep_segments both keep the minimum number of wal segments for replication.
Why those parameters are duplicated?

Andrus.



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

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