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
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.
pgsql-bugs by date
|Next:||From: Dave Page||Date: 2009-05-21 14:54:50|
|Subject: Re: BUG #4820: PostgreSQL service won't start after using Tuning Wizard|
|Previous:||From: Peter Eisentraut||Date: 2009-05-21 12:38:05|
|Subject: Re: DDL triggers|