Re: Postgresql Upgrade from 9.3 to 9.4 failing

Here is locale information

postgres | apigee | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | apigee | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/apigee
+
| | | | |
apigee=CTc/apigee
template1 | apigee | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/apigee
+
| | | | |
apigee=CTc/apigee

env |grep LC
LC_CTYPE=en_US.UTF-8

On Mon, Oct 30, 2017 at 8:35 PM, rammohan ganapavarapu <
rammohanganap(at)gmail(dot)com> wrote:

> OS is Suse 12
>
> On Oct 30, 2017 7:32 PM, "Bruce Momjian" <bruce(at)momjian(dot)us> wrote:
>
>> fOn Mon, Oct 30, 2017 at 11:16:19AM -0700, rammohan ganapavarapu wrote:
>> >
>> > Hi,
>> >
>> > I am getting this error when i try to upgrade from psotgresql 9.3 to
>> 9.4 any
>> > idea ?
>>
>> It looks like it didn't find anything matching. Could it be confused by
>> a non-English locale? We have code that should prevent that, but maybe
>> it isn't working. What OS is this? What is the locale?
>>
>> ------------------------------------------------------------
>> ---------------
>>
>> > "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
>>
>> --
>> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
>> EnterpriseDB http://enterprisedb.com
>>
>> + As you are, so once was I. As I am, so you will be. +
>> + Ancient Roman grave inscription +
>>
>