Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`
| От | Mohan NBSPS |
|---|---|
| Тема | Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog` |
| Дата | |
| Msg-id | CAPCvfWfBR_DmPafxLDBvXhGLmP-+8w-2t27FykDuC=ByG0f6Fw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog` (Muhammad Imtiaz <imtiaz.m@bitnine.net>) |
| Список | pgsql-admin |
thank you.
the replication seems to work.
sorry, my question was incomplete.
I see few very old (over 2 years) WAL files remain in the secondary (primary is clean with only
new WAL files).
On Fri, May 31, 2024 at 11:58 PM Muhammad Imtiaz <imtiaz.m@bitnine.net> wrote:
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 ImtiazOn 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 youRegardsMohan
В списке pgsql-admin по дате отправления: