Re: Warm Standby Weirdness

Wow. I must be blind. Or brain dead.

You're right. That was the issue.

-Sam

On Thu, Aug 19, 2010 at 9:22 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

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