By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,541 Members | 1,427 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,541 IT Pros & Developers. It's quick & easy.

Get Postgre Status and Information

P: n/a
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

Nov 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

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

Nov 23 '05 #2

P: n/a
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:
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

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

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.