Re: : Checksum ERROR when restoring Online Backup - Mailing list pgsql-general

From Venkat Balaji
Subject Re: : Checksum ERROR when restoring Online Backup
Date
Msg-id CAFrxt0izoF84ijYPA0Og-kFT==p0NPV0GoAo3_=NFrFbkN0U3Q@mail.gmail.com
Whole thread Raw
In response to : Checksum ERROR when restoring Online Backup  (Venkat Balaji <venkat.balaji@verse.in>)
Responses Re: : Checksum ERROR when restoring Online Backup
List pgsql-general
Apologies -

I did not mention complete details of PG and OS -

Postgres 9.0.1
Production Operating System version where Postgres is running is as follows -
Linux *prod-server* 2.6.18-194.17.1.el5 #1 SMP Mon Sep 20 07:12:06 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

The server version where I restored the production backup is as follows -
Linux *backup-server* 2.6.18-194.3.1.el5PAE #1 SMP Sun May 2 04:42:25 EDT 2010 i686 i686 i386 GNU/Linux

I read some where that, Postgres datafiles are not architecture independent. 

Please help !

Thanks
Venkat


On Fri, Sep 23, 2011 at 6:11 PM, Venkat Balaji <venkat.balaji@verse.in> wrote:
Hello Everyone,

I am testing the Online Backups of our production databases ( this is part of our disaster recovery plan ).

After restoring the Online Backup, we tried to bring up the cluster and ended up with the following error -

2011-09-23 07:29:04 CDT [24092]: [1-1] FATAL:  incorrect checksum in control file.

Does this message mean, the Online Backup is corrupted or invalid ?

Normally, we get recovery related error messages. This is the first time we are facing a problem like this.

Please help as this is critical for us.

Thanks
Venkat

pgsql-general by date:

Previous
From: Venkat Balaji
Date:
Subject: : Checksum ERROR when restoring Online Backup
Next
From: Alban Hertroys
Date:
Subject: Re: looking for a faster way to do that