how to understand checkpoint information in pg_control data - Mailing list pgsql-general

From Pavan Kumar
Subject how to understand checkpoint information in pg_control data
Date
Msg-id CA+M0sHEpzKNi8zq2jM4JnyBmqb3tPLohRx1JU0SdGzY0w1Re6g@mail.gmail.com
Whole thread Raw
List pgsql-general
Hello Experts,

I have couple of questions on pg_controldata output. 

postgres=# \! pg_controldata $PGDATA|grep checkpoint
Latest checkpoint location:           2/9D029BB0,  
Latest checkpoint's REDO location:    2/97002D60
Latest checkpoint's REDO WAL file:    000000030000000200000097    

Latest checkpoint's TimeLineID:       3
Latest checkpoint's PrevTimeLineID:   3
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID:          0:1732072
Latest checkpoint's NextOID:          40985
Latest checkpoint's NextMultiXactId:  1
Latest checkpoint's NextMultiOffset:  0
Latest checkpoint's oldestXID:        561
Latest checkpoint's oldestXID's DB:   1
Latest checkpoint's oldestActiveXID:  1731942
Latest checkpoint's oldestMultiXid:   1
Latest checkpoint's oldestMulti's DB: 1
Latest checkpoint's oldestCommitTsXid:0
Latest checkpoint's newestCommitTsXid:0
Time of latest checkpoint:            Fri 28 Jun 2019 02:59:24 PM GMT

What is "Latest checkpoint location" 
what is  "Latest checkpoint's REDO location". to my understanding, it is records lsn number. correct me if I am wrong?
Latest checkpoint's REDO WAL file:    000000030000000200000097,  to my understanding  this wal file has the latest record lsn , from where recovery will start and rollover. please correct me if I am wrong ?







--
Regards,

#!  Pavan Kumar
----------------------------------------------
-
Sr. Database Administrator..!

NEXT GENERATION PROFESSIONALS, LLC
Cell    #  267-799-3182 #  pavan.dba27 (Gtalk)  
India   # 9000459083

Take Risks; if you win, you will be very happy. If you lose you will be Wise  

pgsql-general by date:

Previous
From: tony@exquisiteimages.com
Date:
Subject: Re: Analyze command running for 2063 minutes so far
Next
From: Devendra Y
Date:
Subject: Automatic Failover in PostgreSQL using PAF/repmgr