Re: BUG #4820: PostgreSQL service won't start after using Tuning Wizard

On Thu, May 21, 2009 at 10:42 AM, Robert Walker
<r(dot)walker(at)mtcworldwide(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      4820
> Logged by:          Robert Walker
> Email address:      r(dot)walker(at)mtcworldwide(dot)com
> PostgreSQL version: 8.4 beta 2
> Operating system:   Windows XP SP2 32-bit
> Description:        PostgreSQL service won't start after using Tuning Wizard
> Details:
>
> I installed PostgreSQL 8.4 Beta 2 with a completely fresh install, and then
> ran the Tuning Wizard. After a simple run of the Tuning Wizard, the attempt
> to start postmaster via the Windows service would time-out/fail.
>
> The problem is apparently due to the fact that the tuning wizard will add
> the "max_fsm_pages" and "max_fsm_relations" parameters to postgresql.conf,
> despite the fact that 8.4 supposedly no longer uses these parameters.
>
> If I comment out those settings, the service starts without problems.
> Perhaps those settings shouldn't be added to an 8.4 postgresql.conf by the
> wizard, otherwise new users would be alarmed by the resulting failure to
> start the server. Also, nothing in the logs in the pg_log directory was
> written that gave any clue as to why the server wouldn't start.

The current version of the wizard doesn't support 8.4. An update is
currently in qa.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com