Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 027DF2E0085 for ; Fri, 13 Jun 2008 12:54:50 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 18949-05 for ; Fri, 13 Jun 2008 12:54:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vms173005pub.verizon.net (vms173005pub.verizon.net [206.46.173.5]) by developer.postgresql.org (Postfix) with ESMTP id 08DCA2E0079 for ; Fri, 13 Jun 2008 12:54:47 -0300 (ADT) Received: from ridley.home ([71.179.5.175]) by vms173005.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0K2E00EVZRVKKFT0@vms173005.mailsrvcs.net> for pgsql-hackers@postgresql.org; Fri, 13 Jun 2008 10:47:49 -0500 (CDT) Date: Fri, 13 Jun 2008 11:54:20 -0400 From: Robert Treat Subject: Re: Overhauling GUCS In-reply-to: <200806112054.m5BKsNQ23972@momjian.us> To: pgsql-hackers@postgresql.org Cc: Bruce Momjian , Dave Page , "Joshua D. Drake" , Greg Sabino Mullane Message-id: <200806131154.21216.xzilla@users.sourceforge.net> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7bit Content-disposition: inline References: <200806112054.m5BKsNQ23972@momjian.us> User-Agent: KMail/1.9.9 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/622 X-Sequence-Number: 119735 On Wednesday 11 June 2008 16:54:23 Bruce Momjian wrote: > Dave Page wrote: > > On Wed, Jun 11, 2008 at 6:56 PM, Bruce Momjian wrote: > > > Dave Page wrote: > > >> On Mon, Jun 2, 2008 at 5:46 AM, Joshua D. Drake wrote: > > >> > pg_ctl -D data check? > > >> > > > >> > I would +1 that. > > >> > > >> I would also really like to see that - though I'd also like to see an > > >> SQL interface so we can check a config before saving when editing via > > >> pgAdmin or similar. > > > > > > Should this be a TODO? > > > > Yes please. > > Added to TODO: > > * Add pg_ctl option to do a syntax check of postgresql.conf > ISTM we need something that can run inside the db as well, i'm thinking something like pg_check_conf() to go with pg_reload_conf(). Also, these should probably check validity of the pg_hba.conf as well. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL