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

Поиск
Список
Период
Сортировка
От vignesh kumar
Тема Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`
Дата
Msg-id MN0PR20MB4912C1E923B284DC37A7727987F82@MN0PR20MB4912.namprd20.prod.outlook.com
обсуждение исходный текст
Ответ на Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`  (Kashif Zeeshan <kashi.zeeshan@gmail.com>)
Ответы Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`
Список pgsql-admin
You can use slot based replication, so that postgres knows which WAL FILE to retain and delete. however, if you're not concerned about storage, but then the replica go for WAL storage or WAL hub kind of solutions.. 


From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Sent: Sunday, June 2, 2024 5:17:57 PM
To: mohan.nbs.ont@gmail.com <mohan.nbs.ont@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`
 
Hi Mohsn

There can be multiple reasons for that.

1. If the archiving process on the standby is not working correctly, old WAL files will not be removed.
2. Ensure that the configuration settings for WAL management are correctly set on both primary and standby
3. If checkpoints are not happening frequently enough, WAL files will accumulate.

To diagnose the issue

1. Ensure that the replication between the primary and the standby is working correctly.

On Primary Server
SELECT client_addr, state, sent_lsn, write_lsn, flush_lsn, replay_lsn
FROM pg_stat_replication;

On Standby Server
SELECT pg_last_wal_receive_lsn(), pg_last_wal_replay_lsn();


2. Check if the archiving process on the standby is working properly. Look for any errors or warnings in the PostgreSQL logs related to WAL archiving.
3. Ensure that the standby server has the correct restore command configured to fetch the archived WAL files.


Regards
Kashif Zeeshan
Bitnine Global



On Sat, Jun 1, 2024 at 4:01 AM 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 по дате отправления:

Предыдущее
От: vignesh kumar
Дата:
Сообщение: Re: Timeouts in Postgresql JDBC Driver
Следующее
От: vignesh kumar
Дата:
Сообщение: Re: Questions on recovery situations (not urgent)