Re: upgrade from 32 bit to 64 bit within same postgresql major release (e.g. 8.3.x) - Mailing list pgsql-novice

From Devrim GÜNDÜZ
Subject Re: upgrade from 32 bit to 64 bit within same postgresql major release (e.g. 8.3.x)
Date
Msg-id 1262976080.1398.115.camel@hp-laptop2.gunduz.org
Whole thread Raw
In response to upgrade from 32 bit to 64 bit within same postgresql major release (e.g. 8.3.x)  (Matthew Kirk <mkirk01@rcn.com>)
List pgsql-novice
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

Attachment

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: upgrade from 32 bit to 64 bit within same postgresql major release (e.g. 8.3.x)
Next
From: Luis Silva
Date:
Subject: return data before the update