Re: vacuumdb: PANIC: corrupted item pointer - Mailing list pgsql-general

From Richard Huxton
Subject Re: vacuumdb: PANIC: corrupted item pointer
Date
Msg-id 4693EB88.3090405@archonet.com
Whole thread Raw
In response to Re: vacuumdb: PANIC: corrupted item pointer  (AlJeux <aljeux@free.fr>)
Responses Re: vacuumdb: PANIC: corrupted item pointer  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
AlJeux wrote:
> Richard Huxton a écrit :
>> 1. Have you had crashes or other hardware problems recently?
>
> No crash but we changed our server (<= seems the cause).
>
> First try was using a file system copy to reduce downtime as it was two
> same 7.4.x version but the result was not working (maybe related to
> architecture change 32bits => 64 bits) so I finally dropped the db and
> performed an dump/restore. I think, the db was a mix of 32/64 bits files.

Ah! That'll do it. You will get problems with a filesystem copy if
1. The database is running.
2. The architectures aren't identical
3. The installation options are different (a simple date option
difference can cause problems)

I'm surprised you didn't get more problems frankly.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Am I missing something about the output of pg_stop_backup()?
Next
From: Ben
Date:
Subject: Re: Am I missing something about the output of pg_stop_backup()?