| From: | Payal Singh <payal(at)omniti(dot)com> |
|---|---|
| To: | Munnelli Sreenivasulu <srinivas(dot)mca41(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Database configuration details |
| Date: | 2014-09-12 14:12:07 |
| Message-ID: | 20140912141207.GA7998@payal-ThinkPad-T520 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2014-09-12 14:13:32 | Re: Database configuration details |
| Previous Message | Munnelli Sreenivasulu | 2014-09-12 04:56:30 | Database configuration details |