Re: Warm Standby Weirdness - Mailing list pgsql-general

From Tom Lane
Subject Re: Warm Standby Weirdness
Date
Msg-id 6422.1282274535@sss.pgh.pa.us
Whole thread Raw
In response to Warm Standby Weirdness  (Sam Nelson <samn@consistentstate.com>)
Responses Re: Warm Standby Weirdness
Re: Warm Standby Weirdness
List pgsql-general
Sam Nelson <samn@consistentstate.com> writes:
> Here's the output from pg_controldata:

> $ pg_controldata `pwd`
> WARNING: Calculated CRC checksum does not match value stored in file.
> Either the file is corrupt, or it has a different layout than this program
> is expecting.  The results below are untrustworthy.

> pg_control version number:            843
> Catalog version number:               200904091
> Database system identifier:           5473004134245625319
> Database cluster state:               in production
> pg_control last modified:             Wed 31 Dec 1969 05:00:00 PM MST
> Latest checkpoint location:           B000020/0
> Prior checkpoint location:            A000020/0
> Latest checkpoint's REDO location:    B000020/1

This is just an educated guess, but I'm going to bet on 32-bit vs 64-bit.
Are you trying to copy the DB to a machine with different word size?
Won't work.

            regards, tom lane

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Wiki on pgfoundry
Next
From: Greg Smith
Date:
Subject: Re: Wiki on pgfoundry