Thread: BUG #5207: unable to start postgresql server services
The following bug has been logged online: Bug reference: 5207 Logged by: denny saviant Email address: konohablueflash@gmail.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. Thanks a lot.. Regards.. Denny
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 th= ere > 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 properti= es. > 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: =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 finish > my minor project assignment in college. Sounds like you have a bad setting for log_destination in your postgresql.conf file. ...Robert
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 >
On Fri, Nov 27, 2009 at 3:42 AM, Denny Saviant Mohammad <konohablueflash@gmail.com> wrote: > Well, i changed nothing in my postgresql.conf before the accident. Well, someone or something did, because stdmsg isn't ever a legal value, and it didn't put itself into that file. =2E > But, after i try changing value on log_destination from 'stdmsg' into 'cs= vlog', > i got this "2009-11-26 16:07:57 ICTPANIC: =A0could not open control file > "global/pg_control": Permission denied" This would seem to indicate that either the permissions on the PostgreSQL data directory have been changed, or you're trying to start PostgreSQL under the wrong user account. > I changed it into 'syslog', i got this > FATAL: =A0invalid value for parameter "log_destination": "syslog" > > I changed it again into 'eventlog', i got this "2009-11-27 15:28:03 > ICTPANIC: =A0could not open control file "global/pg_control": Permission > denied" again.. > > i also try to change pg_log folder permissions, but nothing happens.. I would suggest that you post to a different mailing list, such as pgsql-novice or pgsql-general. This mailing list is for bug reports, and it doesn't sound to me like there's a bug here. I would start by setting log_destination =3D eventlog - since stdmsg is definitely not going to work - and then ask for help on one of those mailing lists fixing your permissions problem. ...Robert