| From: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Utility program to read parameters of the current database |
| Date: | 2001-02-07 21:36:31 |
| Message-ID: | 200102072136.f17LaVw07492@linda.lfix.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I had a need to read such things as the backend locale and the catalog
version number from the current database, and couldn't find any existing
program to do that.
The attached utility produces this output:
linda:~$ pg_controldata
Log file id: 0
Log file segment: 5
Last modified: Wed Feb 7 19:35:47 2001
Database block size: 8192
Blocks per segment of large relation: 131072
Catalog version number: 200101061
LC_COLLATE: en_GB
LC_CTYPE: en_GB
Log archive directory:
| Attachment | Content-Type | Size |
|---|---|---|
| pg_controldata.c | text/x-csrc | 3.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-02-07 21:42:08 | Re: [INTERFACES] pgAccess fails to launch on HPUX |
| Previous Message | Hannu Krosing | 2001-02-07 21:14:20 | Re: a contrib function to query current locale values |