From: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_archivecleanup standalone bash script |
Date: | 2016-07-31 22:11:43 |
Message-ID: | CAJNY3is888fqBvsWGVMD=q_8jYeOafvcvJaakonbNxSHkNav=Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
I want to hold the wal_files for 30 days on my slaves.
For that reason, I created a script to do that:
*pg_archivecleaup_mv.bash:*
#!/bin/bash -eu
declare -r -x PATH='/usr/local/bin:/usr/bin:/bin';
# We just wanna delete the wal_files older than 30 days
ARCHIVEDIR='/var/lib/pgsql/9.2/archive/'
CHKPOINT=$(find $ARCHIVEDIR -type f -mtime +30 -name '00*' -printf '%f\n' |
sort -r | head -1)
cd $ARCHIVEDIR
/usr/pgsql-${PG_VERSION}/bin/pg_archivecleanup $ARCHIVEDIR $CHKPOINT
find $ARCHIVEDIR -type f -mtime +30 -a -name '00*' -a ! -newer $CHKPOINT
-delete
*recovery.conf:*
archive_cleanup_command = 'exec nice -n 19 ionice -c 2 -n 7
../../bin/pg_archivecleaup_mv.bash -d /var/lib/pgsql/9.2/archive "%r"'
*PROBLEM:*
I'm getting an error message:
> pg_archivecleanup: must specify restartfilename
> Try "pg_archivecleanup --help" for more information.
> archive_cleanup_command "exec nice -n 19 ionice -c 2 -n 7
> ../../bin/pg_archivecleaup_mv.bash -d "../archive" "%r"": return code 512
And I can't figure out what is wrong....
Please, do you guys can help?
Cheers;
Patrick
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-07-31 22:15:45 | Re: Proposal "stack trace" like debugging option in PostgreSQL |
Previous Message | Edson Richter | 2016-07-31 20:32:02 | Re: Proposal "stack trace" like debugging option in PostgreSQL |