| 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: | Whole Thread | Raw Message | 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
| 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 ) |