Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42839=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1XSRaH-0003Aq-Rl
 for pgsql-admin@arkaria.postgresql.org; Fri, 12 Sep 2014 14:12:21 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42839=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1XSRaH-0000JF-Bq
 for pgsql-admin@arkaria.postgresql.org; Fri, 12 Sep 2014 14:12:21 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <payal@omniti.com>) id 1XSRaG-0000J9-Mb
 for pgsql-admin@postgresql.org; Fri, 12 Sep 2014 14:12:20 +0000
Received: from mail-qc0-f180.google.com ([209.85.216.180])
 by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <payal@omniti.com>) id 1XSRaC-0007H7-VT
 for pgsql-admin@postgresql.org; Fri, 12 Sep 2014 14:12:19 +0000
Received: by mail-qc0-f180.google.com with SMTP id c9so861187qcz.39
 for <pgsql-admin@postgresql.org>; Fri, 12 Sep 2014 07:12:12 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20130820;
 h=x-gm-message-state:date:from:to:cc:subject:message-id:references
 :mime-version:content-type:content-disposition:in-reply-to
 :user-agent;
 bh=vFAhOnOOcoMixS3qIfiYyL8tT8+FRvlvGuY7CAsHz4k=;
 b=Aw7AdekCoK/BuSAyu5vXBxRQ704YRiiEvcm4RuQef67Izhg3vD5myn/PtKpBL7AOgQ
 2N20kUTlUg0Xi1xk8UHfi2Fsewuvr5JoBsjAJjpEwnBz+fCQtUmZXqj71SL6fAnCIV5h
 QZfnA44Gazh9qyK56ZcqIkuOb+QYXJSMLKz3Ew1gEBY0zcjQxDD3fJeBjXAhQzKA3ZiX
 N1PDEsqrDn8EQ9PHT7O1TALkXK+VmOXlf3GftibKM33B8lgoAGUJ9XlO/2LYtWA6+iog
 zO31mSa/v+Fy2y3bh3Vb13wv/amyDDA5ASfTL1A3lqse12uzB6uR8Vp7Q39fNsLSZY0j
 qsag==
X-Gm-Message-State: 
 ALoCoQmD/e4c2/l0llq7KM4hwc9sgIrVxHL/adVF7j/Ff+AFR5FFQjLBzmrogTsHhRBil1KVdO42
X-Received: by 10.140.109.75 with SMTP id k69mr12923157qgf.96.1410531129860;
 Fri, 12 Sep 2014 07:12:09 -0700 (PDT)
Received: from payal-ThinkPad-T520
 (static-108-48-124-82.washdc.fios.verizon.net. [108.48.124.82])
 by mx.google.com with ESMTPSA id h2sm3055112qah.35.2014.09.12.07.12.09
 for <multiple recipients>
 (version=TLSv1.2 cipher=RC4-SHA bits=128/128);
 Fri, 12 Sep 2014 07:12:09 -0700 (PDT)
Date: Fri, 12 Sep 2014 10:12:07 -0400
From: Payal Singh <payal@omniti.com>
To: Munnelli Sreenivasulu <srinivas.mca41@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Database configuration details
Message-ID: <20140912141207.GA7998@payal-ThinkPad-T520>
References: 
 <CAB+h9cURqhTAGJOM_wezbv6eN14vFeAY7GB-aheqzu4sdeE0aA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: 
 <CAB+h9cURqhTAGJOM_wezbv6eN14vFeAY7GB-aheqzu4sdeE0aA@mail.gmail.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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