Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group