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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
