Re: [ADMIN] Postgresql Upgrade from 9.3 to 9.4 failing

Any other pointers to resolve this issue?

Thanks,
Ram

On Tue, Oct 31, 2017 at 11:10 AM, rammohan ganapavarapu <
rammohanganap(at)gmail(dot)com> wrote:

> 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 +
>>>
>>
>