Re: Warm Standby Weirdness

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sam Nelson <samn(at)consistentstate(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Warm Standby Weirdness
Date: 2010-08-20 03:22:15
Message-ID: 6422.1282274535@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sam Nelson <samn(at)consistentstate(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2010-08-20 05:09:00 Re: Wiki on pgfoundry
Previous Message Jeff Davis 2010-08-20 02:15:50 Re: Wiki on pgfoundry