Re: pg_upgrade problem from 8.4 to 9.2 problems on OSX - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_upgrade problem from 8.4 to 9.2 problems on OSX
Date
Msg-id 13679.1358570303@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_upgrade problem from 8.4 to 9.2 problems on OSX  (Charles Porter <charles.porter@gmail.com>)
List pgsql-general
Charles Porter <charles.porter@gmail.com> writes:
> Yep. That's it. Thank you
> Maximum data alignment:               4
> Maximum data alignment:               8
> There are several differences, including TOAST chunk 2000 vs 1996.

> I take it that this means that I cannot us pg_upgrade.

Well, not if you want the new server to run 64-bit.  If you install
a 32-bit version of 9.2 it should work.  Note that in a lot of
workloads the server's word width doesn't make that much difference.

            regards, tom lane


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade problem from 8.4 to 9.2 problems on OSX
Next
From: Raghavendra
Date:
Subject: Re: Logging affected rows