Re: [GENERAL] Warm Standby Weirdness

2010-08-22 Thread Tom Lane
Yaroslav Tykhiy writes: > On Thu, Aug 19, 2010 at 11:22:15PM -0400, Tom Lane wrote: >> 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. > Just in case, if anyone ever _really_ needs to

Re: [GENERAL] Warm Standby Weirdness

2010-08-22 Thread Yaroslav Tykhiy
On Thu, Aug 19, 2010 at 11:22:15PM -0400, Tom Lane wrote: > Sam Nelson 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 p

Re: [GENERAL] Warm Standby Weirdness

2010-08-20 Thread Sam Nelson
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 wrote: > Sam Nelson writes: > > Here's the output from pg_controldata: > > > $ pg_controldata `pwd` > > WARNING: Calculated CRC checksum does not match value stored in file

Re: [GENERAL] Warm Standby Weirdness

2010-08-19 Thread Tom Lane
Sam Nelson 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_con

[GENERAL] Warm Standby Weirdness

2010-08-19 Thread Sam Nelson
Let me preface this by saying that I've set up warm standby instances quite a few times. I think I sort of hopefully know what I'm doing. pg_start_backup('stuff'), tar data directory, pg_stop_backup(), copy data directory to warm standby server, extract in data directory, etc. We have two CentOS