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

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: mkirk01(at)rcn(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: upgrade from 32 bit to 64 bit within same postgresql major release (e.g. 8.3.x)
Date: 2010-01-08 18:41:20
Message-ID: 1262976080.1398.115.camel@hp-laptop2.gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Luis Silva 2010-01-08 23:58:30 return data before the update
Previous Message Tom Lane 2010-01-08 18:39:11 Re: upgrade from 32 bit to 64 bit within same postgresql major release (e.g. 8.3.x)