Postgres Pro
Downloads
Home   >   mailing lists

pg_archivecleanup standalone bash script - Mailing list pgsql-general

From Patrick B
Subject pg_archivecleanup standalone bash script
Date
Msg-id CAJNY3is888fqBvsWGVMD=q_8jYeOafvcvJaakonbNxSHkNav=Q@mail.gmail.com
Whole thread Raw
Responses Re: pg_archivecleanup standalone bash script  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
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 

pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Re: Proposal "stack trace" like debugging option in PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: Proposal "stack trace" like debugging option in PostgreSQL