Re: FW: [ADMIN] Setting up of PITR system.

2006-04-01 Thread Rajesh Kumar Mallah
On 4/1/06, Grega Bremec <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: RIPEMD160 > > Rajesh Kumar Mallah wrote: > | Dear Grega , > | > | Thanks for the useful tips and error spotting, > | i am incorporating some of them and testing > | the script in my server . I have conce

Re: FW: [ADMIN] Setting up of PITR system.

2006-04-01 Thread Grega Bremec
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Grega Bremec wrote: | ~ find ${WAL_ARCHIVE} -type f | sort -g | while read archive; do | ~if [ ! "${archive}" = "${REF_FILE}" ]; then Actually, this test is only possible since ${REF_FILE} was expanded using the ${WAL_FILE} mask and will co

Re: FW: [ADMIN] Setting up of PITR system.

2006-04-01 Thread Andy Shellam
Are you talking about tar-ing your completed WAL logs, or the file-system database directory? 1. If you're talking about tar-ing archived WAL logs - the logs you're archiving shouldn't be changing, as they should be archived outside of your PG data directory structure (with the use of archive_comm