Thread: Database configuration details

you can either query pg_settings table for a particular setting, or use the show command in psql.

You can also grep postgresql.conf file directly with the setting name, but be mindful that the values in config file
maynot always reflect the actual value in running database. 
On Fri, Sep 12, 2014 at 10:26:30AM +0530, Munnelli Sreenivasulu wrote:
>  Hi
>
> 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.....
>
> Please provide the commands

-----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@turnstep.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-----