Re: Database configuration details

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: srinivas(dot)mca41(at)gmail(dot)com
Subject: Re: Database configuration details
Date: 2014-09-12 14:13:32
Message-ID: e04436836d5b739b44cef491b61637d1@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

> I need only database current configuration details not for server.
> and maintenance like auto vacuum is enabled or not fro this database and so
> on.....

SELECT * FROM pg_settings;

http://www.postgresql.org/docs/current/static/view-pg-settings.html

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201409121012
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAlQS/1gACgkQvJuQZxSWSsgALgCeNWGkomd3uw7GD9ezTE7LjMFE
gC0AoNh1QyJ1Wba4TMkkJolUHePW/aFC
=XHES
-----END PGP SIGNATURE-----

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Axel Rau 2014-09-13 17:55:12 New certs give "could not accept SSL connection: sslv3 alert certificate unknow"
Previous Message Payal Singh 2014-09-12 14:12:07 Re: Database configuration details