[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    how to understand checkpoint information in pg_control data
From:       Pavan Kumar <pavan.dba27 () gmail ! com>
Date:       2019-06-28 15:09:51
Message-ID: CA+M0sHEpzKNi8zq2jM4JnyBmqb3tPLohRx1JU0SdGzY0w1Re6g () mail ! gmail ! com
[Download RAW message or body]

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  *

[Attachment #3 (text/html)]

<div dir="ltr"><div dir="ltr"><div dir="ltr"><div>Hello \
Experts,</div><div><br></div><div>I have couple of  questions on pg_controldata \
output.  </div><div><br></div><div>postgres=# \! pg_controldata $PGDATA|grep \
checkpoint<br><font color="#0000ff"><b>Latest checkpoint location:                    \
2/9D029BB0,   <br>Latest checkpoint&#39;s REDO location:       2/97002D60<br>Latest \
checkpoint&#39;s REDO WAL file:       000000030000000200000097      \
</b></font><br>Latest checkpoint&#39;s TimeLineID:             3<br>Latest \
checkpoint&#39;s PrevTimeLineID:     3<br>Latest checkpoint&#39;s full_page_writes: \
on<br>Latest checkpoint&#39;s NextXID:                   0:1732072<br>Latest \
checkpoint&#39;s NextOID:                   40985<br>Latest checkpoint&#39;s \
NextMultiXactId:   1<br>Latest checkpoint&#39;s NextMultiOffset:   0<br>Latest \
checkpoint&#39;s oldestXID:               561<br>Latest checkpoint&#39;s \
oldestXID&#39;s DB:     1<br>Latest checkpoint&#39;s oldestActiveXID:   \
1731942<br>Latest checkpoint&#39;s oldestMultiXid:     1<br>Latest checkpoint&#39;s \
oldestMulti&#39;s DB: 1<br>Latest checkpoint&#39;s oldestCommitTsXid:0<br>Latest \
checkpoint&#39;s newestCommitTsXid:0<br>Time of latest checkpoint:                    \
Fri 28 Jun 2019 02:59:24 PM GMT<br><br></div><div>What is &quot;Latest checkpoint \
location&quot;  <br>what is   &quot;Latest checkpoint&#39;s REDO location&quot;. to \
my understanding, it is records lsn number. correct me if I am \
wrong?</div><div>Latest checkpoint&#39;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 \
?</div><div><br></div><div><br><br><br></div><div><br></div><div><br \
clear="all"></div><br>-- <br><div class="gmail_signature" dir="ltr"><font \
color="#990000"><b><font face="&#39;trebuchet ms&#39;, sans-serif">Regards,<br><br>#! \
Pavan Kumar<br>----------------------------------------------</font></b>-<br><b><font \
face="&#39;trebuchet ms&#39;, sans-serif">Sr. Database \
Administrator..!</font></b></font><br><span \
style="color:rgb(34,34,34);line-height:19px;font-family:arial,sans-serif;font-size:13px;border-collapse:collapse"><b><span \
style="color:white;font-family:Georgia,serif;font-size:7.5pt;background-color:red">NEXT \
GENERATION PROFESSIONALS, LLC</span></b></span><br><font color="#990000" \
face="&#39;trebuchet ms&#39;, sans-serif"><b>Cell      #   267-799-3182 #   \
pavan.dba27 (Gtalk)    </b></font><div><font color="#990000" face="&#39;trebuchet \
ms&#39;, sans-serif"><b>India    # 9000459083</b></font><br><br><blockquote \
style="margin:0px 0px 0px \
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid"><b><font \
color="#000099" face="&#39;trebuchet ms&#39;, sans-serif">Take Risks; if you win, you \
will be very happy. If you lose you will be Wise   \
</font></b></blockquote></div></div></div></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]