[ADMIN] Recovery issue

Hi L:sters, We're at postgresql 8.2.5. I'm running PITR backups on our production server and copying the resulting tarball and the WAL logs to our reporting server. I restart the reporting server and begin re-playing logs. Everything works fine for about 3 days until a network outage creates a g

[ADMIN] another PITR recovery question

I'm running postgres 8.2.5 and I'm running a PITR restore on a remote machine. The archived logs are being restored at a rate of about 5 every 3 minutes I was reading in compressed logs and uncompressing them as they are being restored. I am now reading in uncompressed logs straight into the rest

Re: [ADMIN] another PITR recovery question

May be helpful to add on some memory information to my question: shared_buffers - 250MB work_mem - 75 MB maintenance_work_mem - 100MB max_fsm_pages- 150 wal_buffers - 96 checkpoint_segments - 32 And some information on the machine (VMWARE) ipcs -l -- Shared Me