Help | Site Map
Connecting Tech Pros Worldwide
 
 
LinkBack Thread Tools
  #1  
Old November 23rd, 2005, 01:38 AM
Shelby Cain
Guest
 
Posts: n/a
Default Postgresql 8.0 beta 1 service issue

When I enable log_statement_stats AND log_parser_stats
in my postgresql.conf file and attempt the start the
service I receive the following error:

"Could not start the PostgreSQL Database SErver
8.0-beta1 service on Local Computer. The service did
not return an error."

Attempting to start the server manually using the
following commandline:

C:\PostgreSQL\8.0-beta1\bin>runas /user:postgres
"C:\PostgreSQL\8.0-beta1\bin\pg
_ctl.exe start -N "pgsql-8.0-beta1" -D
"C:\PostgreSQL\8.0-beta1\data\""

Results in a console window appearing with "postmater
starting" which is immediately followed up with a
dialog box:

"The application failed to initialize properly
(0xc0000142). Click OK to terminate the application."

This is on a Windows 2000 SP4 system with PostgreSQL
installed via the beta installer.

Regards,

Shelby Cain





__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

  #2  
Old November 23rd, 2005, 01:38 AM
Bruce Momjian
Guest
 
Posts: n/a
Default Re: Postgresql 8.0 beta 1 service issue


Right, you can not use them both because the statistics per statement
and per-stage can't be done with the one set of system counters we have.

The server logs should show the cause with a description of this.

This wasn't documented in the docs but I just added something.

---------------------------------------------------------------------------

Shelby Cain wrote:[color=blue]
> When I enable log_statement_stats AND log_parser_stats
> in my postgresql.conf file and attempt the start the
> service I receive the following error:
>
> "Could not start the PostgreSQL Database SErver
> 8.0-beta1 service on Local Computer. The service did
> not return an error."
>
> Attempting to start the server manually using the
> following commandline:
>
> C:\PostgreSQL\8.0-beta1\bin>runas /user:postgres
> "C:\PostgreSQL\8.0-beta1\bin\pg
> _ctl.exe start -N "pgsql-8.0-beta1" -D
> "C:\PostgreSQL\8.0-beta1\data\""
>
> Results in a console window appearing with "postmater
> starting" which is immediately followed up with a
> dialog box:
>
> "The application failed to initialize properly
> (0xc0000142). Click OK to terminate the application."
>
> This is on a Windows 2000 SP4 system with PostgreSQL
> installed via the beta installer.
>
> Regards,
>
> Shelby Cain
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> New and Improved Yahoo! Mail - Send 10MB messages!
> http://promotions.yahoo.com/new_mail
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>[/color]

--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

 

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles