Postgresql 8.0 beta 1 service issue

Started by Shelby Cainover 21 years ago3 messagesgeneral
Jump to latest
#1Shelby Cain
alyandon@yahoo.com

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

#2Bruce Momjian
bruce@momjian.us
In reply to: Shelby Cain (#1)
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:

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

-- 
  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
#3Shelby Cain
alyandon@yahoo.com
In reply to: Bruce Momjian (#2)
Re: Postgresql 8.0 beta 1 service issue

Thanks for the info.

--- Bruce Momjian <pgman@candle.pha.pa.us> wrote:

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.

__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail