Postgres Pro
Downloads
Home   >   mailing lists

Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog` - Mailing list pgsql-admin

From Mohan NBSPS
Subject Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`
Date
Msg-id CAPCvfWfBR_DmPafxLDBvXhGLmP-+8w-2t27FykDuC=ByG0f6Fw@mail.gmail.com
Whole thread Raw
In response to Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`  (Muhammad Imtiaz <imtiaz.m@bitnine.net>)
List pgsql-admin
Tree view
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 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 by date:

Previous
From: Teja Jakkidi
Date:
Subject: Re: pg_dump and restore without indexes
Next
From: Mohan NBSPS
Date:
Subject: Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`