Re: pg_upgrade problem from 8.4 to 9.2 problems on OSX - Mailing list pgsql-general
| From | Charles Porter |
|---|---|
| Subject | Re: pg_upgrade problem from 8.4 to 9.2 problems on OSX |
| Date | |
| Msg-id | CA+s3HynZUdLK4i_jmFAxF2iNxSiwu75XJ7gbahjM8opbDmapVw@mail.gmail.com Whole thread Raw |
| In response to | Re: pg_upgrade problem from 8.4 to 9.2 problems on OSX (Bruce Momjian <bruce@momjian.us>) |
| Responses |
Re: pg_upgrade problem from 8.4 to 9.2 problems on OSX
Re: pg_upgrade problem from 8.4 to 9.2 problems on OSX |
| List | pgsql-general |
Bruce -
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.
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
pgsql-general by date: