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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

re: Get Postgre Status and Information

On Mon, Oct 11, 2004 at 10:04:09AM +0200, m.b. wrote:[color=blue]
> 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[/color]

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

-Dom

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

re: Get Postgre Status and Information

There's also pg_config.

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

-tfo

On Oct 11, 2004, at 3:04 AM, m.b. wrote:
[color=blue]
> 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[/color]


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly