From: | AI Rumman <rummandba(at)gmail(dot)com> |
---|---|
To: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | When does pg_archivecleanup work? |
Date: | 2014-03-11 23:03:42 |
Message-ID: | CAGoODpdU=0wXkYDnXd5Mevnicgn2cgFnNphO1qhO7tP6twt=jw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
As I have very low wal_keep_segments compare to my wal generation, I am
collecting archive wal files at slave.
Now in order to clean up archive wal collection directory at slave, I used
"archive_cleanup_command".
I watched that after archive wal files were pilling up at slave and after
certain point it was cleared up.
But still I didn't get the idea when it will be executed and clean up my
directory.
Example: recovery.conf that I used:
standby_mode = 'on' # enables stand-by (readonly) mode
primary_conninfo = 'host= 10.0.0.1 port= 5432 user= replicator
password=replicator'
trigger_file = '/pgdata/pgsql.trigger.5432'
restore_command = 'cp /archivewal/%f %p'
archive_cleanup_command = '$HOME/bin/pg_archivecleanup /archivewal %r'
Any idea please.
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2014-03-12 02:33:13 | Re: How do I track down a possible locking problem? |
Previous Message | Francisco Figueiredo Jr. | 2014-03-11 22:19:14 | Re: Recovering from failed transaction |