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

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
>