Thread: Get Postgre Status and Information

Hello everybody,

is there a possibility to get some useful information about
my postgresql installation, its configuration, the locales
and information about the databases which run on the system ?
so i would be able to compare 3 different systems and see
the difference between them from postgres's view

thx
Marcel

On Mon, Oct 11, 2004 at 10:04:09AM +0200, m.b. wrote:
> is there a possibility to get some useful information about
> my postgresql installation, its configuration, the locales
> and information about the databases which run on the system ?
> so i would be able to compare 3 different systems and see
> the difference between them from postgres's view

Try doing "SELECT * FROM pg_settings".  That should give you most of the
information you need.

-Dom

There's also pg_config.

http://www.postgresql.org/docs/7.4/static/app-pgconfig.html

-tfo

On Oct 11, 2004, at 3:04 AM, m.b. wrote:

> Hello everybody,
>
> is there a possibility to get some useful information about
> my postgresql installation, its configuration, the locales
> and information about the databases which run on the system ?
> so i would be able to compare 3 different systems and see
> the difference between them from postgres's view
>
> thx
> Marcel
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster