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/97002D60Latest 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 *
