Re: BUG #5660: Can't start db service if specify effective_io_concurrency

From: tkbysh2000(at)yahoo(dot)co(dot)jp
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5660: Can't start db service if specify effective_io_concurrency
Date: 2010-09-17 03:59:43
Message-ID: 20100917125531.BB5C.A495B709@yahoo.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

Thank you very much for your quick support.
I've understood. Please close this bug ticket.

I hope add comment e.g"(unix only)" onto effective_io_concurrency line
in postgresql.conf if possible.

Regards.

--
<tkbysh2000(at)yahoo(dot)co(dot)jp>

On Thu, 16 Sep 2010 10:36:19 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "Mikio" <tkbysh2000(at)yahoo(dot)co(dot)jp> writes:
> > I'm using postgresql 9.0 rc1, and I specified 10 for
> > effective_io_concurrency in postgresql.conf.
> > I restarted postgresql windows service, but the service didn't start.
>
> This is unsurprising: you can only set effective_io_concurrency on
> platforms that have posix_fadvise(), which I rather doubt Windows does.
>
> > I looked windows event viewer, I found an event from PostgreSQL, and it was
> > below.(The characters in the message were broken.)
>
> >> FATAL: p[^"effective_io_concurrency"マ更ナま〓>
> Hm, what I get when I try that on a machine without posix_fadvise()
> is
>
> FATAL: parameter "effective_io_concurrency" cannot be changed
>
> I think you have some other configuration problem that's messing up
> your log entries.
>
> regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message tkbysh2000 2010-09-17 05:10:13 Re: BUG #5661: The character encoding in logfile is confusing.
Previous Message Ashesh Vashi 2010-09-17 03:51:09 Re: BUG #5650: Postgres service showing as stopped when in fact it is running