Keep wal segments

Поиск
Список
Период
Сортировка
От Prince Pathria
Тема Keep wal segments
Дата
Msg-id CAON0Dax8eMK-yto4n3ZL70+1-51msRvKh3m+243GO1+=ihtbOw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Keep wal segments
Список pgsql-admin
Дерево обсуждения
Hi,

On postgresql10, I'm facing issue of "requested WAL segment 000000010000007E0000003F has already been removed" a lot. I resync slaves with pg_basebackup and still some days after the same thing happens with same or other replica node.

I have kept 

wal_keep_segment = 1024
wal_buffers = 16MB
min_wal_size = 1GB
max_wal_size =  2GB
archive_mode = on
archive_command =  cp %p /var/lib/pgsql/10/archive/%f
wal_level = replica                     
synchronous_commit = on
synchronous_standby_names = 'pgslave01'

Can I keep wal segments for some duration(eg 24 hours) ?

I'm using two replicas with one in sync and other in potential state.Is one synchronous_standby_names fine?

Is there any option to remove archive wal after 30 days or 50GB?

And how archiving the wal logs help? The missing segment is "000000010000007E0000003F" is in archive dir but how can I make it in use?

Thanks!!

Prince Pathria Systems Architect Evive +91 9478670472 goevive.com

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Problems when initdb on AIX 5.3
Следующее
От: Flavio Henrique Araque Gurgel
Дата:
Сообщение: Re: Keep wal segments