Magnus Hagander escribió:
> On Wed, Feb 20, 2008 at 09:36:43AM -0300, Alvaro Herrera wrote:
> > IMO restart-only settings should not be changeable via the new SQL
> > command. It's just too messy to deal with that.
>
> I respectfully disagree. It should be settable. You need a restart, sure,
> and the GUI app should tell you that. But you shuld be able to change them.
> (for example, pgadmin can restart the server just fine for you if you're on
> Windows)
What if the server doesn't come back up? Say, because you increased
shared_buffers and now it doesn't fit on the kernel limits. If you
haven't made arrangements to be able to edit the postgresql.conf file
beforehand, you're hosed.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.