Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Admin > Re: Postgres wi...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 5115 of 5413
Post > Topic >>

Re: Postgres windows service shutdowns after start

by ineyman@[EMAIL PROTECTED] ("Igor Neyman") Jul 2, 2008 at 03:06 PM

"stats_start_collector" is an obsolete parameter in 8.3, that's why PG
wouldn't start with it.

Igor

-----Original Message-----
From: pgsql-admin-owner@[EMAIL PROTECTED]
 On Behalf Of bogdad
Sent: Wednesday, July 02, 2008 2:38 PM
To: pgsql-admin@[EMAIL PROTECTED]
 [ADMIN] Postgres windows service shutdowns after start


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 =3D 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.=20

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-tp1
8244024p18244024.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


--=20
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


--=20
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
 




 2 Posts in Topic:
Re: Postgres windows service shutdowns after start
ineyman@[EMAIL PROTECTED]  2008-07-02 15:06:18 
Re: Postgres windows service shutdowns after start
bogdad@[EMAIL PROTECTED]   2008-07-02 12:25:56 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Oct 13 21:28:09 CDT 2008.