X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 1308530EB23 for ; Tue, 10 Jun 2003 20:58:14 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 38029-05 for ; Tue, 10 Jun 2003 17:58:03 -0300 (ADT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by svr1.postgresql.org (Postfix) with ESMTP id 8820130EB3F for ; Tue, 10 Jun 2003 17:58:02 -0300 (ADT) Received: from [66.219.92.2] (HELO temoku) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3109005; Tue, 10 Jun 2003 13:58:11 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Richard Huxton , pgsql-performance@postgresql.org Subject: Re: Re-ordering .CONF params ... questions for this list Date: Tue, 10 Jun 2003 13:57:24 -0700 User-Agent: KMail/1.4.3 References: <200306101101.46304.josh@agliodbs.com> <200306102005.11578.richardh@archonet.com> In-Reply-To: <200306102005.11578.richardh@archonet.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200306101357.24596.josh@agliodbs.com> X-Archive-Number: 200306/43 X-Sequence-Number: 2127 Richard, > Logging & Debugging > I'd like this near the top, but then I use syslogging. With a new install= I=20 go=20 > in and check tcpip_socket etc, fix the logging and just see if everything= is=20 > working. Then I go in and do a little tuning. > Actually, maybe the syslog sub-section should go above the others - say= =20 where=20 > you'll log to, and then what you'll log. Of course, I'm biased since I us= e=20 > syslog. I have no objection to moving the syslog section. Any other opinions? > Client Connection Defaults/Other/password_encryption > This should probably go in the security section. Actually, looking at it= =20 > "dynamic_librar_path" is in the wrong place too - cut & past error? Not the way I read the docs; according to the docs: password_encryption is whether or not the statement "ALTER USER joe_schmoe= =20 WITH PASSWORD 'xxxyyy'" is encrypted by default even if you don't use the= =20 "WITH ENCRYPTION" option. And it is SET-able on each client connection, b= y=20 regular users. So it goes in "CLIENT CONNECTION SETTINGS". "dynamic_library_path", while less obvious, is also SETable on each client= =20 connection. I'd be happy to revise this if someone understands/uses this= =20 option and has a better idea where to put it. > Not sure it would help that much - the comments need a URL to the relevan= t=20 > page in the online docs though. A couple more lines of comments too: Given that we're running out of time, I wasn't going to touch any of the=20 comments in PostgreSQL.conf.sample. Instead, I was going to leave the=20 comments as-is, and post extensive comments on Techdocs before 7.4 beta.=20= =20 Then, in 7.5 or 8.0 we can re-comment .conf. --=20 -Josh Berkus Aglio Database Solutions San Francisco