Postgresql Upgrade from 9.3 to 9.4 failing

From: rammohan ganapavarapu <rammohanganap(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgresql Upgrade from 9.3 to 9.4 failing
Date: 2017-10-30 18:16:19
Message-ID: CALm_VjjCYcZG7UnDYU6VvgC9dOADaQKieGEmMXDeWuoyd6kUog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ferrell, Denise D CTR NSWCDD, H11 2017-10-30 18:38:04 Re: [Non-DoD Source] Re: Database Error
Previous Message Stephen Frost 2017-10-30 15:47:06 Re: Bad recovery: no pg_xlog/RECOVERYXLOG