Обсуждение: [ADMIN] Postgresql Upgrade from 9.3 to 9.4 failing
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
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@momjian.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 + -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
OS is Suse 12
On Oct 30, 2017 7:32 PM, "Bruce Momjian" <bruce@momjian.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@momjian.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 +
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@gmail.com> wrote:
OS is Suse 12On Oct 30, 2017 7:32 PM, "Bruce Momjian" <bruce@momjian.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@momjian.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 +
Any other pointers to resolve this issue?
Thanks,
Ram
On Tue, Oct 31, 2017 at 11:10 AM, rammohan ganapavarapu <rammohanganap@gmail.com> wrote:
Here is locale informationpostgres | 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/apigeetemplate1 | apigee | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/apigee +| | | | | apigee=CTc/apigeeenv |grep LCLC_CTYPE=en_US.UTF-8On Mon, Oct 30, 2017 at 8:35 PM, rammohan ganapavarapu <rammohanganap@gmail.com> wrote:OS is Suse 12On Oct 30, 2017 7:32 PM, "Bruce Momjian" <bruce@momjian.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@momjian.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 +