Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`

Поиск
Список
Период
Сортировка
От Muhammad Imtiaz
Тема Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`
Дата
Msg-id CANwR1OQ4Fij4YxeNOVV1EyJ_WnE6AbORajyYh9oQZaO-12nOPA@mail.gmail.com
обсуждение исходный текст
Ответ на postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`  (Mohan NBSPS <mohan.nbs.ont@gmail.com>)
Ответы Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`
Список pgsql-admin
Дерево обсуждения
Hi ,

Ensure the following:

• Replication is functioning correctly between the primary and secondary servers, with no lag.

• The archive_command parameter is properly configured in the database settings.

Regards,

Muhammad Imtiaz

On Sat, 1 Jun 2024, 04:01 Mohan NBSPS, <mohan.nbs.ont@gmail.com> wrote:
Hello Community,

Although the WAL retaining settings are default (max size 1GB),
`wal_keep_segments` is 25, checkpoint target is 2.5 minutes(default).
I noticed a few WAL files in secondary nodes (streaming replication) `pg_xlog`
folder.

What could be the reason why postgresql did not delete these ?

Thank you
Regards
Mohan

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

Предыдущее
От: Mohan NBSPS
Дата:
Сообщение: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`
Следующее
От: Debraj Manna
Дата:
Сообщение: Timeouts in Postgresql JDBC Driver