I have added this to /contrib. It meets the needs of several posters.
> 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:
>
>
Content-Description: pg_controldata.c
[ Attachment, skipping... ]
> Oliver Elphick Oliver.Elphick@lfix.co.uk
> Isle of Wight http://www.lfix.co.uk/oliver
> PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
> ========================================
> "But the LORD is in his holy temple; let all the earth
> keep silence before him." Habakkuk 2:20
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026
