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

Re: BUG #5207: unable to start postgresql server services

From: Denny Saviant Mohammad <konohablueflash(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5207: unable to start postgresql server services
Date: 2009-11-27 08:42:56
Message-ID: 43221fa90911270042kff3412bl7c71e0dceb7d747e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Well, i changed nothing in my postgresql.conf before the accident..

But, after i try changing value on log_destination from 'stdmsg' into 'csvlog',
i got this "2009-11-26 16:07:57 ICTPANIC:  could not open control file
"global/pg_control": Permission denied"

I changed it into 'syslog', i got this
FATAL:  invalid value for parameter "log_destination": "syslog"

I changed it again into 'eventlog', i got this "2009-11-27 15:28:03
ICTPANIC:  could not open control file "global/pg_control": Permission
denied" again..

i also try to change pg_log folder permissions, but nothing happens..



On 11/26/09, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Sat, Nov 21, 2009 at 9:13 AM, denny saviant
> <konohablueflash(at)gmail(dot)com> wrote:
>>
>> The following bug has been logged online:
>>
>> Bug reference:      5207
>> Logged by:          denny saviant
>> Email address:      konohablueflash(at)gmail(dot)com
>> PostgreSQL version: 8.4.1
>> Operating system:   windows xp pro sp3
>> Description:        unable to start postgresql server services
>> Details:
>>
>> I installed my postgresql 8.4.1 successfully without any problems. But
>> there
>> was a problem,the server service won't run. After spending hours of
>> searching i postgre mailing list. I able to solve it by following the
>> instruction in
>> http://archives.postgresql.org/pgsql-admin/2006-05/msg00168.php .
>> which is by assigning Log on as local system account in services
>> properties.
>> And voila, it works..
>>
>> couple days later, this kind of trouble come again exactly after i restart
>> w3svc service and restart my PC. (i know it after checking the log).
>>
>> And here's the windows event log that shows the failure..
>>
>> Waiting for server startup...
>>
>> LOG:  unrecognized "log_destination" key word: "stdmsg"
>>
>> FATAL:  invalid value for parameter "log_destination": "stdmsg"
>>
>> Is there anyone know how to solve this?
>> I am currently using this postgresql server as my dbms of choice to finish
>> my minor project assignment in college.
>
> Sounds like you have a bad setting for log_destination in your
> postgresql.conf file.
>
> ...Robert
>

In response to

Responses

pgsql-bugs by date

Next:From: Jaime CasanovaDate: 2009-11-27 10:17:00
Subject: Re: BUG #5216: pgFouine 1.1 not working correctly, when LC_MESSAGES is "es_ES.UTF-8"
Previous:From: Guillaume SmetDate: 2009-11-27 07:11:33
Subject: Re: BUG #5216: pgFouine 1.1 not working correctly, when LC_MESSAGES is "es_ES.UTF-8"

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