public inbox for [email protected]help / color / mirror / Atom feed
Delete archived WALs on PRIMARY NODE 3+ messages / 2 participants [nested] [flat]
* Delete archived WALs on PRIMARY NODE @ 2025-08-19 20:52 Daniel Cifuentes <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Daniel Cifuentes @ 2025-08-19 20:52 UTC (permalink / raw) To: [email protected] Hello, I have a cluster with Postgres 16.4 Pgpool-II 4.5.4 The problem that I am having is that the directory for archives is getting full with all the old archives. I have done some testing and proved that the replication is ok. I have read about the pg_archivecleanup command but the documentation says that the command is designed for standby servers (PostgreSQL: Documentation: 16: pg_archivecleanup <https://www.postgresql.org/docs/16/pgarchivecleanup.html;). What I have noticed is that Pgpool 4.5.4 documentation indicates: Archive mode on /var/lib/pgsql/archivedirPgpool-II + Watchdog Setup Example <https://www.pgpool.net/docs/pgpool-II-4.5.4/en/html/example-cluster.html; While 4.6.2 version says: Archive mode offPgpool-II + Watchdog Setup Example <https://www.pgpool.net/docs/latest/en/html/example-cluster.html; So a solution would be doing an upgrade and setting off the archive mode? Is that the best solution? Thank you in advance for your help. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Delete archived WALs on PRIMARY NODE @ 2025-08-20 09:15 Bo Peng <[email protected]> parent: Daniel Cifuentes <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Bo Peng @ 2025-08-20 09:15 UTC (permalink / raw) To: Daniel Cifuentes <[email protected]>; [email protected] <[email protected]> Hi, > So a solution would be doing an upgrade and setting off the archive mode? Is that the best solution? > Thank you in advance for your help. Upgrade is not necessary. You can disable archive_mode in PostgreSQL and modify the follow_primary and online_recovery scripts to disable archive_mode. --- Bo Peng <[email protected]> SRA OSS K.K. TEL: 03-5979-2701 FAX: 03-5979-2702 Mobile: 080-7752-0749 URL: https://www.sraoss.co.jp/ ________________________________________ 差出人: Daniel Cifuentes <[email protected]> 送信: 2025 年 8 月 20 日 (水曜日) 5:52 宛先: [email protected] <[email protected]> 件名: Delete archived WALs on PRIMARY NODE Hello, I have a cluster with Postgres 16.4 Pgpool-II 4.5.4 The problem that I am having is that the directory for archives is getting full with all the old archives. I have done some testing and proved that the replication is ok. I have read about the pg_archivecleanup command but the documentation says that the command is designed for standby servers (PostgreSQL: Documentation: 16: pg_archivecleanup). What I have noticed is that Pgpool 4.5.4 documentation indicates: Archive mode on /var/lib/pgsql/archivedirPgpool-II + Watchdog Setup Example While 4.6.2 version says: Archive mode offPgpool-II + Watchdog Setup Example So a solution would be doing an upgrade and setting off the archive mode? Is that the best solution? Thank you in advance for your help. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Delete archived WALs on PRIMARY NODE @ 2025-08-20 15:48 Daniel Cifuentes <[email protected]> parent: Bo Peng <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Daniel Cifuentes @ 2025-08-20 15:48 UTC (permalink / raw) To: Bo Peng <[email protected]>; +Cc: [email protected] <[email protected]> 👍 Daniel Cifuentes reaccionó a través de Gmail <https://www.google.com/gmail/about/?utm_source=gmail-in-product&utm_medium=et&utm_campaign=e...; El mié, 20 ago 2025 a las 4:15, Bo Peng (<[email protected]>) escribió: > Hi, > > > So a solution would be doing an upgrade and setting off the archive > mode? Is that the best solution? > > Thank you in advance for your help. > > Upgrade is not necessary. > > You can disable archive_mode in PostgreSQL and modify the follow_primary > and online_recovery scripts to disable archive_mode. > > --- > Bo Peng <[email protected]> > SRA OSS K.K. > TEL: 03-5979-2701 FAX: 03-5979-2702 > Mobile: 080-7752-0749 > URL: https://www.sraoss.co.jp/ > > > ________________________________________ > 差出人: Daniel Cifuentes <[email protected]> > 送信: 2025 年 8 月 20 日 (水曜日) 5:52 > 宛先: [email protected] < > [email protected]> > 件名: Delete archived WALs on PRIMARY NODE > > > > > > > > > > > > Hello, I have a cluster with > Postgres 16.4 > Pgpool-II 4.5.4 > The problem that I am having is that the directory for archives is getting > full with all the old archives. I have done some testing and proved that > the replication is ok. > I have read about the pg_archivecleanup command but the documentation says > that the command is designed for standby servers (PostgreSQL: > Documentation: 16: pg_archivecleanup). > > > What I have noticed is that Pgpool 4.5.4 documentation indicates: > > > Archive mode > on > /var/lib/pgsql/archivedirPgpool-II + Watchdog Setup Example > > > While 4.6.2 version says: > > > Archive mode > offPgpool-II + Watchdog Setup Example > > So a solution would be doing an upgrade and setting off the archive mode? > Is that the best solution? > Thank you in advance for your help. > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-08-20 15:48 UTC | newest] Thread overview: 3+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-08-19 20:52 Delete archived WALs on PRIMARY NODE Daniel Cifuentes <[email protected]> 2025-08-20 09:15 ` Bo Peng <[email protected]> 2025-08-20 15:48 ` Daniel Cifuentes <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox