From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | Richard Huxton <richardh(at)archonet(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Re-ordering .CONF params ... questions for this list |
Date: | 2003-06-10 20:57:24 |
Message-ID: | 200306101357.24596.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-hackers pgsql-performance |
Richard,
> Logging & Debugging
> I'd like this near the top, but then I use syslogging. With a new install I
go
> in and check tcpip_socket etc, fix the logging and just see if everything is
> working. Then I go in and do a little tuning.
> Actually, maybe the syslog sub-section should go above the others - say
where
> you'll log to, and then what you'll log. Of course, I'm biased since I use
> 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
> "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
WITH PASSWORD 'xxxyyy'" is encrypted by default even if you don't use the
"WITH ENCRYPTION" option. And it is SET-able on each client connection, by
regular users. So it goes in "CLIENT CONNECTION SETTINGS".
"dynamic_library_path", while less obvious, is also SETable on each client
connection. I'd be happy to revise this if someone understands/uses this
option and has a better idea where to put it.
> Not sure it would help that much - the comments need a URL to the relevant
> 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
comments in PostgreSQL.conf.sample. Instead, I was going to leave the
comments as-is, and post extensive comments on Techdocs before 7.4 beta.
Then, in 7.5 or 8.0 we can re-comment .conf.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-06-10 21:22:28 | Re: [GENERAL] MySQL gets $19.5 MM |
Previous Message | Josh Berkus | 2003-06-10 20:47:34 | Re: [GENERAL] MySQL gets $19.5 MM |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-06-10 21:19:59 | Re: Proposal to Re-Order Postgresql.Conf, part II |
Previous Message | Dennis Björklund | 2003-06-10 20:22:42 | Re: Character encoding |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-06-10 21:28:43 | Re: Re-ordering .CONF params ... questions for this list |
Previous Message | Tom Lane | 2003-06-10 20:56:45 | Re: Hash or merge join instead of inner loop |