Re: : Checksum ERROR when restoring Online Backup

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(dot)balaji(at)verse(dot)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
>