: Checksum ERROR when restoring Online Backup
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
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:
Show quoted text
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
On 23/09/11 13:53, Venkat Balaji wrote:
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/LinuxThe 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/LinuxI read some where that, Postgres datafiles are not architecture
independent.
They (the WAL files) are not, and it looks like you're trying to restore
a 64-bit version onto a 32-bit server. That's not going to work. A
pg_dump/restore works of course, and if you need replication then Slony
can handle this.
--
Richard Huxton
Archonet Ltd
Thanks Richard !
I realized that, I was restoring on an 32 bit server.
Regards,
Venkat
On Fri, Sep 23, 2011 at 6:59 PM, Richard Huxton <dev@archonet.com> wrote:
Show quoted text
On 23/09/11 13:53, Venkat Balaji wrote:
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/LinuxThe 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/LinuxI read some where that, Postgres datafiles are not architecture
independent.They (the WAL files) are not, and it looks like you're trying to restore a
64-bit version onto a 32-bit server. That's not going to work. A
pg_dump/restore works of course, and if you need replication then Slony can
handle this.--
Richard Huxton
Archonet Ltd