Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group