pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabase configuration details
3+ messages / 3 participants
[nested] [flat]
* Database configuration details
@ 2014-09-12 04:56 Munnelli Sreenivasulu <srinivas.mca41@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Munnelli Sreenivasulu @ 2014-09-12 04:56 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Database configuration details
@ 2014-09-12 14:12 Payal Singh <payal@omniti.com>
parent: Munnelli Sreenivasulu <srinivas.mca41@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Payal Singh @ 2014-09-12 14:12 UTC (permalink / raw)
To: Munnelli Sreenivasulu <srinivas.mca41@gmail.com>; +Cc: 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Database configuration details
@ 2014-09-12 14:13 Greg Sabino Mullane <greg@turnstep.com>
parent: Munnelli Sreenivasulu <srinivas.mca41@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Greg Sabino Mullane @ 2014-09-12 14:13 UTC (permalink / raw)
To: pgsql-admin; +Cc: srinivas.mca41@gmail.com
-----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-----
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2014-09-12 14:13 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-09-12 04:56 Database configuration details Munnelli Sreenivasulu <srinivas.mca41@gmail.com>
2014-09-12 14:12 ` Payal Singh <payal@omniti.com>
2014-09-12 14:13 ` Greg Sabino Mullane <greg@turnstep.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox