Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group