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

Поиск
Список
Период
Сортировка
От Robert Walker
Тема BUG #4820: PostgreSQL service won't start after using Tuning Wizard
Дата
Msg-id 200905211442.n4LEgcZK065437@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4820: PostgreSQL service won't start after using Tuning Wizard
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4820
Logged by:          Robert Walker
Email address:      r.walker@mtcworldwide.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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: DDL triggers
Следующее
От: Dave Page
Дата:
Сообщение: Re: BUG #4820: PostgreSQL service won't start after using Tuning Wizard