Обсуждение: Output of pg_controldata

Поиск
Список
Период
Сортировка

Output of pg_controldata

От
Virupaksha Kanjilal
Дата:
Does anyone know what the fields in the output of pg_controldata mean?

Thanks
Viru

Re: Output of pg_controldata

От
Alvaro Herrera
Дата:
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

Re: Output of pg_controldata

От
Virupaksha Kanjilal
Дата:
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