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