Postgres Pro
Downloads
Home   >   mailing lists

Re: Output of pg_controldata - Mailing list pgsql-admin

From Virupaksha Kanjilal
Subject Re: Output of pg_controldata
Date
Msg-id CADm2AyNad_Axj82ZUdK8op7ANrJS26GXCHZMU0r_72jjae1Wpw@mail.gmail.com
Whole thread Raw
In response to Re: Output of pg_controldata  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-admin
Tree view
Hi

I want to know the meaning of these fields specifically : 

Latest checkpoint location:           0/5F000020
Prior checkpoint location:            0/5E000020
Latest checkpoint's REDO location:    0/5F000020

Latest checkpoint's NextXID:          0/1894

Latest checkpoint's NextMultiXactId:  1
Latest checkpoint's NextMultiOffset:  0

Thanks
Viru



On Fri, May 24, 2013 at 2:53 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
Virupaksha Kanjilal escribió:
> Does anyone know what the fields in the output of pg_controldata mean?

A lot of people.  What do you want to know, precisely?

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

pgsql-admin by date:

Previous
From: Rodrigo Barboza
Date:
Subject: Re: How do I know my table is bloated?
Next
From: Sergey Konoplev
Date:
Subject: Re: How do I know my table is bloated?