[ADMIN] base backup requirements for PITR

2012-11-28 Thread Andrew W. Gibbs
Postgres Admin Wizards, I am trying to manage an 8.4 database whose ingest rate is sufficiently high that doing base backups on it causes it to fall unacceptably behind. To deal with this, I want to do WAL shipping to another server that is in warm standby mode, and then on that server perform th

Re: [ADMIN] base backup requirements for PITR

2012-11-30 Thread Gabriele Bartolini
Hi Andrew, Il 29/11/12 02:52, Andrew W. Gibbs ha scritto: That said, I'm wondering whether I created the base backup with reliably correct procedures or merely was lucky. PostgreSQL documentation on how continuous archiving works is clear, but you need to follow exactly what it says and have a

Re: [ADMIN] base backup requirements for PITR

2012-12-01 Thread Albe Laurenz
Gabriele Bartolini wrote: > Il 29/11/12 02:52, Andrew W. Gibbs ha scritto: >> That said, I'm wondering whether I created the base backup with >> reliably correct procedures or merely was lucky. > In order to simplify the management of disaster recovery solutions for > PostgreSQL, we have recently

Re: [ADMIN] base backup requirements for PITR

2012-12-03 Thread Gabriele Bartolini
Hi Laurenz, Il 01/12/12 12:18, Albe Laurenz ha scritto: Gabriele, I understand that you want to spread the word, but the OP's problem was a different one: You are right. I totally missed that. I skimmed the email (very quickly) and thought that in that particular context Andrew was referring to

Re: [ADMIN] base backup requirements for PITR

2012-12-03 Thread Albe Laurenz
Gabriele Bartolini wrote: >> Gabriele, I understand that you want to spread the word, >> but the OP's problem was a different one: > You are right. I totally missed that. I skimmed the email (very quickly) > and thought that in that particular context Andrew was referring to PITR > in general. I