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

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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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