Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XSRbb-0003Ce-5C for pgsql-admin@arkaria.postgresql.org; Fri, 12 Sep 2014 14:13:43 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XSRba-0001Vj-Jq for pgsql-admin@arkaria.postgresql.org; Fri, 12 Sep 2014 14:13:42 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XSRbZ-0001TG-Bc for pgsql-admin@postgresql.org; Fri, 12 Sep 2014 14:13:41 +0000 Received: from zql.com ([206.222.31.58]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XSRbS-0005hE-FD for pgsql-admin@postgresql.org; Fri, 12 Sep 2014 14:13:39 +0000 Received: from localhost ([127.0.0.1]) by zql.com with smtp (Exim 4.68) (envelope-from ) id 1XSRbQ-0006w1-JL; Fri, 12 Sep 2014 10:13:32 -0400 From: "Greg Sabino Mullane" To: pgsql-admin@postgresql.org CC: srinivas.mca41@gmail.com CC: srinivas.mca41@gmail.com Subject: Re: Database configuration details X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: Date: Fri, 12 Sep 2014 14:13:32 -0000 X-Mailer: JoyMail 3.0.1 Message-ID: X-Pg-Spam-Score: -0.0 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org -----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