Re: : Checksum ERROR when restoring Online Backup

From: Richard Huxton <dev(at)archonet(dot)com>
To: Venkat Balaji <venkat(dot)balaji(at)verse(dot)in>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: : Checksum ERROR when restoring Online Backup
Date: 2011-09-23 13:29:46
Message-ID: 4E7C89CA.9020306@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/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.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reuven M. Lerner 2011-09-23 13:31:55 Re: Speed of lo_unlink vs. DELETE on BYTEA
Previous Message Alban Hertroys 2011-09-23 13:21:27 Re: looking for a faster way to do that