Re: pg_upgrade problem from 8.4 to 9.2 problems on OSX

On Wed, Jan 16, 2013 at 06:47:12PM -0800, Charles Porter wrote:
> Bruce -
>
> 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.

That is correct. I have updated the pg_upgrade error to suggest 32-bit
vs 64-bit binaries.

---------------------------------------------------------------------------

>
> Thanks,
>
> Charles
>
> [511][/Library/PostgreSQL8.4/bin]$ ./pg_controldata /Library/PostgreSQL8.4/data
> pg_control version number: 843
> Catalog version number: 200904091
> Database system identifier: 5381387821761095614
> Database cluster state: shut down
> pg_control last modified: Wed Jan 16 13:23:37 2013
> Latest checkpoint location: 3A/D507B5A0
> Prior checkpoint location: 3A/D507B55C
> Latest checkpoint's REDO location: 3A/D507B5A0
> Latest checkpoint's TimeLineID: 1
> Latest checkpoint's NextXID: 0/22082243
> Latest checkpoint's NextOID: 75427786
> Latest checkpoint's NextMultiXactId: 1
> Latest checkpoint's NextMultiOffset: 0
> Time of latest checkpoint: Wed Jan 16 13:23:37 2013
> Minimum recovery ending location: 0/0
>
> Maximum data alignment: 4
>
> Database block size: 8192
> Blocks per segment of large relation: 131072
> WAL block size: 8192
> Bytes per WAL segment: 16777216
> Maximum length of identifiers: 64
> Maximum columns in an index: 32
> Maximum size of a TOAST chunk: 2000
> Date/time type storage: 64-bit integers
> Float4 argument passing: by value
> Float8 argument passing: by reference
>
> =================================================
>
> [512][/Library/PostgreSQL8.4/bin]$ cd ../../PostgreSQL/9.2/bin/
> [513][/Library/PostgreSQL/9.2/bin]$ ./pg_controldata /Volumes/DISK2/Postgres/
> 9.2/data
> pg_control version number: 922
> Catalog version number: 201204301
> Database system identifier: 5834152691411927039
> Database cluster state: shut down
> pg_control last modified: Wed Jan 16 13:23:58 2013
> Latest checkpoint location: 0/17A5580
> Prior checkpoint location: 0/17A5520
> Latest checkpoint's REDO location: 0/17A5580
> Latest checkpoint's TimeLineID: 1
> Latest checkpoint's full_page_writes: on
> Latest checkpoint's NextXID: 0/1000
> Latest checkpoint's NextOID: 16393
> Latest checkpoint's NextMultiXactId: 1
> Latest checkpoint's NextMultiOffset: 0
> Latest checkpoint's oldestXID: 989
> Latest checkpoint's oldestXID's DB: 1
> Latest checkpoint's oldestActiveXID: 0
> Time of latest checkpoint: Wed Jan 16 13:23:58 2013
> Minimum recovery ending location: 0/0
> Backup start location: 0/0
> Backup end location: 0/0
> End-of-backup record required: no
> Current wal_level setting: minimal
> Current max_connections setting: 100
> Current max_prepared_xacts setting: 0
> Current max_locks_per_xact setting: 64
>
> Maximum data alignment: 8
>
> Database block size: 8192
> Blocks per segment of large relation: 131072
> WAL block size: 8192
> Bytes per WAL segment: 16777216
> Maximum length of identifiers: 64
> Maximum columns in an index: 32
> Maximum size of a TOAST chunk: 1996
> Date/time type storage: 64-bit integers
> Float4 argument passing: by value
> Float8 argument passing: by value
>
>
>

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +