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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
