Postgres Pro
Downloads
Home   >   mailing lists

PITR for postgresql-7.3 - Mailing list pgsql-general

From Mary Ellen Fitzpatrick
Subject PITR for postgresql-7.3
Date
Msg-id 46BCA6EA.8000102@bu.edu
Whole thread Raw
Responses Re: PITR for postgresql-7.3  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
Tree view 
Hi,

We are running postgresql-7.3.3 and we had a hardware controller and
disk failure on the system.  And of course the database does not appear
to be backup anywhere.

I was reading about PITR and was wondering if that is applicable to my
version.  We do have pg_xlog files and I am wondering if there is anyway
to recover the data.

The error we get when trying to access a very important table is

"Invalid page header in block 51 of vuser"

Any help would be appreciated.
(upgrades and backups lessons learned)

--
Thanks
Mary Ellen

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: UPDATES hang every 5 minutes
Next
From: Tom Lane
Date:
Subject: Re: Timestamp in pg_dump output, was Re: How I can know a back up database is up to date