Re: Can't start PostgreSQL service on Windows and it's quite urgent - Mailing list pgsql-novice

From Thomas Kellerer
Subject Re: Can't start PostgreSQL service on Windows and it's quite urgent
Date
Msg-id n8ktqf$2fr$1@ger.gmane.org
Whole thread Raw
In response to Can't start PostgreSQL service on Windows and it's quite urgent  (mnts <mnts@ngs.ru>)
Responses Re: Can't start PostgreSQL service on Windows and it's quite urgent
List pgsql-novice
mnts schrieb am 31.01.2016 um 12:56:
> Well i'm new with postgre and dont know much, so i cant figure out this
> problem by myself. Though it might be easy for someone knowing.
>
> The problem is my postgre sevice dont start giving me
> *FATAL:  900 is outside the valid range for parameter
> "autovacuum_analyze_scale_factor" (0 .. 100)*
>
> I'm using Win 2008R2 server, and all was OK before today, though i tried
> some tweaks changing shared_buffers, effective_cache_size and some other
> from RESOURCE USAGE group.
> I'm tried to disable autovacuum and track_counts but it didnt do a thing.
>

The error message is pretty obvious

> The problem is my postgre sevice dont start giving me
> *FATAL:  900 is outside the valid range for parameter
> "autovacuum_analyze_scale_factor" (0 .. 100)*

is pretty obvious.

You have changed postgresql.conf with a value for autovacuum_analyze_scale_factor that is invalid.

Change that value back (the default is 0.1) and you should be able to start the service again (unless you have changed
otherconfiguration properties to an invalid value as well) 


Thomas

P.S.: it's Postgres, not Postgre


pgsql-novice by date:

Previous
From: mnts
Date:
Subject: Can't start PostgreSQL service on Windows and it's quite urgent
Next
From: mnts
Date:
Subject: Re: Can't start PostgreSQL service on Windows and it's quite urgent