hi
I'm looking at upgrading a server from 32 bit Centos 4.4 to 64 bit Centos 4.7. I'll also be going from Postgres
8.3.3/32bit to Postgres 8.3.9/64 bit. I know that if I were upgrading from 8.3 to 8.4 I would need to do a dump and
restore. But I can't find documentation that tells me whether I need to dump/restore when just moving from 32 bits to
64bits...
Do I?
Thanks
Matthew Kirk <mkirk01@rcn.com> writes:
> But I can't find documentation that tells me whether I need to dump/restore when just moving from 32 bits to 64
bits...
Yes, you do.
regards, tom lane
On Fri, 2010-01-08 at 13:31 -0500, Matthew Kirk wrote:
> I'm looking at upgrading a server from 32 bit Centos 4.4 to 64 bit
> Centos 4.7. I'll also be going from Postgres 8.3.3/32 bit to Postgres
> 8.3.9/64 bit. I know that if I were upgrading from 8.3 to 8.4 I would
> need to do a dump and restore. But I can't find documentation that
> tells me whether I need to dump/restore when just moving from 32 bits
> to 64 bits...
You need to dump/restore. On-disk data format also changes between two
archs.
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz