Utility program to read parameters of the current database

Поиск
Список
Период
Сортировка
От Oliver Elphick
Тема Utility program to read parameters of the current database
Дата
Msg-id 200102072136.f17LaVw07492@linda.lfix.co.uk
обсуждение исходный текст
Ответы Re: Utility program to read parameters of the current database  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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:


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
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: a contrib function to query current locale values
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [INTERFACES] pgAccess fails to launch on HPUX