[ClusterLabs] Postgresql pg_archive directory seems to keep growing

"Tomcsányi, Domonkos" tomcsanyid at modit.hu
Wed Mar 11 16:00:14 UTC 2015


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/users/attachments/20150311/7e3a982e/attachment-0003.html>


More information about the Users mailing list