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 'csvl=
og',
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@gmail.com> wrote:
> On Sat, Nov 21, 2009 at 9:13 AM, denny saviant
> <konohablueflash@gmail.com> wrote:
>>
>> The following bug has been logged online:
>>
>> Bug reference: =A0 =A0 =A05207
>> Logged by: =A0 =A0 =A0 =A0 =A0denny saviant
>> Email address: =A0 =A0 =A0konohablueflash@gmail.com
>> PostgreSQL version: 8.4.1
>> Operating system: =A0 windows xp pro sp3
>> Description: =A0 =A0 =A0 =A0unable 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 resta=
rt
>> 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: =A0unrecognized "log_destination" key word: "stdmsg"
>>
>> FATAL: =A0invalid 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 fini=
sh
>> my minor project assignment in college.
>
> Sounds like you have a bad setting for log_destination in your
> postgresql.conf file.
>
> ...Robert
>