I'm using pgpool-II + PostgreSQL 8.4 on three servers: primary + standby1 + standby2. Replication mode is "on" Load balance mode is "on" (between primary and standby1)
I followed the official tutorial to configure online recovery with PITR: http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html#online-recovery
There is a tar command in script "copy-base-backup":
tar -C /data -zcf pgsql.tar.gz pgsql
So all my PG cluster directory being copied while script is running:
ls -1 /srv/pg/data/ PG_VERSION archive # directory with postgres archive files backup_label.old base global pg_clog pg_hba.conf pg_ident.conf pg_log pg_multixact pg_stat_tmp pg_subtrans pg_tblspc pg_twophase pg_xlog pgpool_recovery pgpool_recovery_pitr pgpool_remote_start postgresql.conf postmaster.opts postmaster.pid recovery.conf recovery.done
How can I safely remove old archive logs from primary and from standby nodes? There are about 30Gb of archives per day on my nodes.