pg_controldata ( some values missing)

From: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_controldata ( some values missing)
Date: 2003-04-24 01:06:26
Message-ID: b87dbr$lco$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I wondering about some data missing after the execution of
pg_controldata (pg_control last modified and Time of latest
checkpoint), is it normal ?

pg_control version number: 72
Catalog version number: 200211021
Database cluster state: in production
pg_control last modified:
Current log file ID: 17
Next log file segment: 184
Latest checkpoint location: 11/B6F1C554
Prior checkpoint location: 11/B617B6F4
Latest checkpoint's REDO location: 11/B6BAF378
Latest checkpoint's UNDO location: 0/0
Latest checkpoint's StartUpID: 17
Latest checkpoint's NextXID: 56642758
Latest checkpoint's NextOID: 1648295
Time of latest checkpoint:
Database block size: 8192
Blocks per segment of large relation: 131072
Maximum length of identifiers: 64
Maximum number of function arguments: 32
Date/time type storage: Floating point
Maximum length of locale name: 128
LC_COLLATE: en_US
LC_CTYPE: en_US

#select version();
version
-------------------------------------------------------------
PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96

Ciao
Gaetano

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2003-04-24 01:17:16 point-in-time recovery
Previous Message Gaetano Mendola 2003-04-24 00:51:43 \dp ( show priviledges for functions )