Postgresql Upgrade from 9.3 to 9.4 failing

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




Hi,

I am getting this error when i try to upgrade from psotgresql 9.3 to 9.4 any idea ?

"The old cluster lacks some required control information:", " checkpoint next XID", " latest checkpoint next OID", " latest checkpoint next MultiXactId", " latest checkpoint next MultiXactOffset", " first WAL segment after reset", " maximum alignment", " block size", " large relation segment size", " WAL block size", " WAL segment size", " maximum identifier length", " maximum number of indexed columns", " maximum TOAST chunk size", " dates/times are integers?", " float8 argument passing method", " data checksum version", "", "Cannot continue without required control information, terminating", "Failure, exiting", "ERROR: PostgreSQL Upgrade FAILED" 


9.3 control data:

pg_control version number:            937
Catalog version number:               201306121 
Database system identifier:           6376954828819496929
Database cluster state:               shut down
pg_control last modified:             Sun 29 Oct 2017 12:07:59 PM UTC
Latest checkpoint location:           8/2B62C18
Prior checkpoint location:            8/2AE97D0
Latest checkpoint's REDO location:    8/2B62C18
Latest checkpoint's REDO WAL file:    000000010000000800000002
Latest checkpoint's TimeLineID:       1
Latest checkpoint's PrevTimeLineID:   1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID:          0/1557113 
Latest checkpoint's NextOID:          84904 #
Latest checkpoint's NextMultiXactId:  1 
Latest checkpoint's NextMultiOffset:  0 
Latest checkpoint's oldestXID:        1309
Latest checkpoint's oldestXID's DB:   1
Latest checkpoint's oldestActiveXID:  0
Latest checkpoint's oldestMultiXid:   1
Latest checkpoint's oldestMulti's DB: 1
Fake LSN counter for unlogged rels:   0/1
Minimum recovery ending location:     0/0
Min recovery ending loc's timeline:   0
Backup start location:                0/0
Backup end location:                  0/0
End-of-backup record required:        no
Current wal_level setting:            hot_standby
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
Data page checksum version:           0


9.4 control data;

pg_control version number:            942
Catalog version number:               201409291
Database system identifier:           6482307767365018368
Database cluster state:               shut down
pg_control last modified:             Sun 29 Oct 2017 02:20:20 PM UTC
Latest checkpoint location:           0/16F3D60
Prior checkpoint location:            0/16F3CF8
Latest checkpoint's REDO location:    0/16F3D60
Latest checkpoint's REDO WAL file:    000000010000000000000001
Latest checkpoint's TimeLineID:       1
Latest checkpoint's PrevTimeLineID:   1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID:          0/1317
Latest checkpoint's NextOID:          12753
Latest checkpoint's NextMultiXactId:  1
Latest checkpoint's NextMultiOffset:  0
Latest checkpoint's oldestXID:        1308
Latest checkpoint's oldestXID's DB:   1
Latest checkpoint's oldestActiveXID:  0
Latest checkpoint's oldestMultiXid:   1
Latest checkpoint's oldestMulti's DB: 1
Time of latest checkpoint:            Sun 29 Oct 2017 02:20:20 PM UTC
Fake LSN counter for unlogged rels:   0/1
Minimum recovery ending location:     0/0
Min recovery ending loc's timeline:   0
Backup start location:                0/0
Backup end location:                  0/0
End-of-backup record required:        no
Current wal_level setting:            hot_standby
Current max_connections setting:      0
Current max_prepared_xacts setting:   200
Current max_locks_per_xact setting:   8
Maximum data alignment:           
Database block size:                  0
Blocks per segment of large relation: 1093850759
WAL block size:                       8192
Bytes per WAL segment:                131072
Maximum length of identifiers:        8192
Maximum columns in an index:          16777216
Maximum size of a TOAST chunk:        64
Date/time type storage:               64-bit integers
Float4 argument passing:              by reference
Float8 argument passing:              by reference
Data page checksum version:           1996


Thanks,
Ram

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux