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

From: Muhammad Imtiaz <imtiaz(dot)m(at)bitnine(dot)net>
To: mohan(dot)nbs(dot)ont(at)gmail(dot)com
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`
Date: 2024-06-01 03:58:03
Message-ID: CANwR1OQ4Fij4YxeNOVV1EyJ_WnE6AbORajyYh9oQZaO-12nOPA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)nbs(dot)ont(at)gmail(dot)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
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Debraj Manna 2024-06-01 09:40:35 Timeouts in Postgresql JDBC Driver
Previous Message Mohan NBSPS 2024-05-31 23:00:52 postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`