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

From: "Robert Walker" <r(dot)walker(at)mtcworldwide(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4820: PostgreSQL service won't start after using Tuning Wizard
Date: 2009-05-21 14:42:38
Message-ID: 200905211442.n4LEgcZK065437@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2009-05-21 14:54:50 Re: BUG #4820: PostgreSQL service won't start after using Tuning Wizard
Previous Message Peter Eisentraut 2009-05-21 12:38:05 Re: DDL triggers