[ClusterLabs] Postgresql pg_archive directory seems to keep growing

[NAKAHIRA Kazutomo]

Hi, Domi

archive_cleanup_command is used for recovery.conf
and cleanup works only slave node.

Administrator have to delete archive files in the master node
who's own responsibility.

Old archive files can be removed from running master after base_backup.

"START WAL LOCATION:" in the $PGDATA/backup_label shows latest archive
file name that must be keep in the archive directory.

And *.history file just before latest archive file must be keep
in the archive directory.

The other older files can be delete from archive directory.

Strictly, how to determine deletable archive files in the running
master is a little complex because it is needed that consider latest
checkpoint status in the slave(REDO point and timeline ID).

But, it is not a cause for concern when slave is synchronous with master.

Best regards,
Kazutomo NAKAHIRA

On 2015/03/12 1:00, "Tomcsányi, Domonkos" wrote:
> Hello everyone,
>
> I just have a quick question: I have a PostgreSQL master-slave cluster
> set up using Pacemaker pretty much following this guide:
> http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster
> I ended up with a working cluster, we tested it, failover happened just
> fine, slave became master etc. so we put it in production.
> Now what I see is that the pg_archive directory keeps on growing. I
> thought it was supposed to get cleaned after the slave received the WAL
> files needed to be in sync with the master, but that didn't happen.
> I'm using the following archive command:
> archive_command = 'cp %p /var/lib/postgresql/9.3/main/pg_archive/%f'
>
> It feels weird to me, since I also saw some guides telling me to using
> rsync here, or use cp, but then run a cron job to regurarly rsync the
> contents of the directory to the slave node. Somehow I can't figure out
> if rsync is really needed or not, to be honest I can't truly figure out
> how exactly Postgres works in terms of replication.
> I also tried adding the following to my RA config:
> archive_cleanup_command="/usr/lib/postgresql/9.3/bin/pg_archivecleanup
> /var/lib/postgresql/9.3/main/pg_archive %r"
>
> but it didn't change the fact that my archive directory seems to be just
> growing and growing, and it has some files in it that were not touched
> in a month or so.
>
> I'm confused, so I'd really appreciate any help :).
>
> Thank you,
> Domi
>
>
>
> _______________________________________________
> Users mailing list: Users at clusterlabs.org
> http://clusterlabs.org/mailman/listinfo/users
>
> Project Home: http://www.clusterlabs.org
> Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> Bugs: http://bugs.clusterlabs.org
>


-- 
NTT オープンソースソフトウェアセンタ
中平 和友
TEL: 03-5860-5135 FAX: 03-5463-6490
Mail: nakahira_kazutomo_b1 at lab.ntt.co.jp