| 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: | Whole Thread | Raw Message | 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 |