Skip site navigation (1) Skip section navigation (2)

Postgres windows service shutdowns after start

From: bogdad <bogdad(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgres windows service shutdowns after start
Date: 2008-07-02 18:38:19
Message-ID: 18244024.post@talk.nabble.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

I have a postgres 8.3 service working on win2003 server, 
it works fine.

But, when i alter postgresql.conf adding the stats_starts_collector = on (
or even false, which bugs me to the end) the service starts and immedeately
stops. If I revert the change, service works again.

The event log is clear, the pg_log is empty.

My login is local admin, and due to restrictions in environment, i currently
cannot runas /user:postgres posmaster.exe to retrieve the stderr or stdout
of postgres. 

So the questions:

1) Is it really connected to stats collector? [ the part in brackets makes
me think it's not]
2) Maybe, there is a forsaken way for admin user to run postgres?
3) How to proceed?
4) Is there a way to syntax check .conf?

(I know that I can send the .conf home and run postgres there,
but don't like this option)

Thanks in advance,
Vladimir.
-- 
View this message in context: http://www.nabble.com/Postgres-windows-service-shutdowns-after-start-tp18244024p18244024.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


Responses

pgsql-admin by date

Next:From: Igor NeymanDate: 2008-07-02 19:06:18
Subject: Re: Postgres windows service shutdowns after start
Previous:From: Kevin GrittnerDate: 2008-07-02 18:07:29
Subject: Re: Change a character in a text field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group