Re: [HACKERS] PITR Recovery Question

2010-06-04 Thread Florian Pflug
On Jun 4, 2010, at 7:05 , Gnanakumar wrote: >> If some of those WAL segments still reside in pg_xlog, you'll either need > to teach your restore_command to fetch them from there. Note that you cannot > recover "in reverse". > > My pg_xlog/ and walarchive/ directory locations are > "/usr/local/pgsq

Re: [HACKERS] PITR Recovery Question

2010-06-03 Thread Gnanakumar
g/ directory, this will not work out in this situation? Is my understanding right? -Original Message- From: Florian Pflug [mailto:f...@phlo.org] Sent: Thursday, June 03, 2010 8:50 PM To: gna...@zoniac.com Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] PITR Recovery Question Hi, I&#

Re: [HACKERS] PITR Recovery Question

2010-06-03 Thread Florian Pflug
Hi, I'll try to answer your questions below, but in the future please post questions concerning the usage and administration of postgres to pgsql-general or pgsql-admin. This list focus is the development of new features and bugfixes. On Jun 3, 2010, at 15:37 , Gnanakumar wrote: > PITR SETUP DE

[HACKERS] PITR Recovery Question

2010-06-03 Thread Gnanakumar
Hi, My production server is running PostgreSQL v8.2.3 on CentOS release 5.2 (Final). I've setup PITR in my production server. For some reason, after setting up PITR, we're not able to manage and maintain it. Because of this our WAL archive drive become full (100% use) approximately after 1 mont