Re: Database configuration details

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 may not 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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux