Re: WINDOWS : PostgreSQL 8.4 Server Start Error

Hi.

At an environment(Ver8.4.2),a simmilar error happened and we could work
around
setting postgresql.conf

client_min_messages = log
to
client_min_messages = notice .

I'm not sure that your error is same,
but can you try this?

//Your message is following
//2010-06-07 14:11:40 ICT LOG: incomplete startup packet
//So I guess that you set client_min_messages = log or higher.

(2010/06/07 16:49), Zery wrote:
> Craig,
>
> Nothing is usefull or barely i understand :-)
>
> In pg_log i only find this :
> 2010-06-07 14:11:40 ICT LOG: could not receive data from client: An
> operation was attempted on something that is not a socket.
>
>
> 2010-06-07 14:11:40 ICT LOG: incomplete startup packet
>
> In event viewer i found :
>
> : Waiting for server startup..
> and
> : Timed out waiting for server startup
>
> I have removed PowerDVD and still it doesn't solve the problem, this
> the second time it happen, the first time i couldn't figure out what's
> the problem, so I reinstalled Windows, this time i found the problem
> is crashing with PowerDVD, but i'm avoiding to reinstall Windows.
>
> I read some other way is to manage Firewall, i did turn off the
> firewall, still it dosn't solve either.
>
> Any other way??
>
>
>
>> On 6/7/10, Craig Ringer<craig(at)postnewspapers(dot)com(dot)au> wrote:
>>
>>> On 07/06/10 08:34, Zery wrote:
>>>
>>>> All,
>>>>
>>>>
>>>> I'm a newbie in postgresql, a few days ago i install postgresql
>>>> 8.4.3.1 and it works fine, yesterday i install cyberlink powerdvd 9
>>>> and after that my postgresql server cannot start, it give the
>>>> following error info :
>>>>
>>>> " The postgresql-8.4 - PostgreSQL Server 8.4 service is starting....
>>>> The postgresql-8.4 - PostgreSQL Server 8.4 service could not be
>>>> started.
>>>>
>>>> The service did not report an error
>>>> ....................................."
>>>>
>>> Look in the Windows event log for details on why it might be failing to
>>> start. You can find Event Viewer in Adminstrative Tools in the Control
>>> Panel.
>>>
>>> Also look at the PostgreSQL log files in
>>> C:\Program Files\postgresql\8.4\data\pg_log
>>> (I think that path is right, by default anyway) and see if there's
>>> anything useful there.
>>>
>>> I wouldn't be too surprised to find that PowerDVD has installed
>>> something it shouldn't into C:\WINDOWS\SYSTEM32.
>>>
>>> --
>>> Craig Ringer
>>>
>>>
>>
>

--
================================================
Kenichiro Tanaka
K.K.Ashisuto
http://www.ashisuto.co.jp/english/index.html
================================================