Re: Upgrading a 32-bit build to a 64-bit build

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: "Steven Flatt" <steven(dot)flatt(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrading a 32-bit build to a 64-bit build
Date: 2007-04-20 18:58:02
Message-ID: 878xcmzxdx.fsf@suzuka.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Steven Flatt" <steven(dot)flatt(at)gmail(dot)com> writes:

> I can't seem to find an answer to this.
>
> If I upgrade a 32-bit Postgres build to a 64-bit Postgres build
> (same version), will the data files be compatible or do I have to do
> a dump and restore of the database?

They will not be compatible.

> Is the answer the same for 8.1 and 8.2?

Yes.

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Vanasco 2007-04-20 20:52:37 unique constraint on 2 columns
Previous Message Steven Flatt 2007-04-20 18:50:51 Upgrading a 32-bit build to a 64-bit build