Re: wal logs in pg_xlog

On Tue, 28 Jun 2005, Nasir Iqbal Danish wrote:

> Please provide me if u can some script to identify which one is latest file 
> so that I can copy this to some other place.
> One more question. Is there a way to build or configure the database server 
> to replicate pg_xlogs ?

I use this fairly simple method:

LASTLOG=`ls -rt /pg_xlog/ | grep -v "backup\|archive" | tail -1`

There might be something more elegant.  I also use the following method to get 
rid of archived wal files that are older than the oldest base backup I am 
keeping:

OLDESTFILE=$PITRBASEDIR/`ls -t $PITRBASEDIR | tail -1`/backup_label

if [ -f $OLDESTFILE ]; then
 	/usr/bin/find $PITRDESTDIR -type f -not -newer $OLDESTFILE \
 		-exec rm -f \{\} \;
fi

Your mileage may vary, but it appears to work for me.

-- 
Jeff Frost, Owner 	
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954