Обсуждение: windows service not working

<div style="text-align: left;">Hi,<br />  I just installed postgresql 8.3 on my windows xp desktop.  For some reason, I
amnot able to start it as a service from the control panel (I have set it to start manually).  But if I bring up
pgAdminIII UI, I can connect to the db from there.<br /><br />any ideas on how to get the windows service working?<br
/>thx,<br/>-kalyan<br />PS:  Sorry for the previous incomplete email.<br /></div><br /><hr />Going green? <a
href="http://green.msn.com/galleries/photos/photos.aspx?gid=164&ocid=T003MSN51N1653A"target="_new">See the top 12
foodsto eat organic.</a> 

Kalyan,

> Hi,
>   I just installed postgresql 8.3 on my windows xp desktop.  For some
> reason, I am not able to start it as a service from the control panel (I
> have set it to start manually).  But if I bring up pgAdmin III UI, I can
> connect to the db from there.


if you can connect to the database, there is something running. Either
the database not as a service, or something else.

So, propably your service fails to start because the port 5432
(propably the default) is still in use.

you should fire up eventvwr and check the application log. There you
may find more about the reason why you cannot start your service.

Also have a look at $PGDATA/pg_log (default below
PostgreSQL/8.3/data), if anything is written there.

best wishes

Harald




--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!

<div style="text-align: left;"></div><style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style><div style="text-align: left;">Hi,<br />  Thanks for all the responses.  From the event viewer what I got was
thatthe service was failing b'cos it thought that the database was already and locked by a postmaster.pid file.  Just
deletingthat file helped.  Now, the service has started and a new postmaster.pid file has been created. <br />  For
now,I'm all set, although I'd be curious how I could have gotten into this situation.<br /><br />best,<br />-k<br
/></div><br/><hr id="stopSpelling" />> Date: Fri, 11 Apr 2008 15:31:37 +0200<br />> From:
haraldarminmassa@gmail.com<br/>> To: kalyan_v@hotmail.com<br />> Subject: Re: [pgadmin-support] windows service
notworking<br />> CC: pgadmin-support@postgresql.org<br />> <br />> Kalyan,<br />> <br />> > Hi,<br
/>>> I just installed postgresql 8.3 on my windows xp desktop. For some<br />> > reason, I am not able to
startit as a service from the control panel (I<br />> > have set it to start manually). But if I bring up pgAdmin
IIIUI, I can<br />> > connect to the db from there.<br />> <br />> <br />> if you can connect to the
database,there is something running. Either<br />> the database not as a service, or something else.<br />> <br
/>>So, propably your service fails to start because the port 5432<br />> (propably the default) is still in
use.<br/>> <br />> you should fire up eventvwr and check the application log. There you<br />> may find more
aboutthe reason why you cannot start your service.<br />> <br />> Also have a look at $PGDATA/pg_log (default
below<br/>> PostgreSQL/8.3/data), if anything is written there.<br />> <br />> best wishes<br />> <br
/>>Harald<br />> <br />> <br />> <br />> <br />> -- <br />> GHUM Harald Massa<br />> persuadere
etprogrammare<br />> Harald Armin Massa<br />> Spielberger Straße 49<br />> 70435 Stuttgart<br />>
0173/9409607<br/>> fx 01212-5-13695179<br />> -<br />> EuroPython 2008 will take place in Vilnius, Lithuania -
Staytuned!<br /><br /><hr />Going green? <a
href="http://green.msn.com/galleries/photos/photos.aspx?gid=164&ocid=T003MSN51N1653A"target="_new">See the top 12
foodsto eat organic.</a> 

Am 12.04.2008 um 03:21 schrieb Kalyan Vaidyanathan:

> Hi,
>   Thanks for all the responses.  From the event viewer what I got
> was that the service was failing b'cos it thought that the database
> was already and locked by a postmaster.pid file.  Just deleting that
> file helped.  Now, the service has started and a new postmaster.pid
> file has been created.
>   For now, I'm all set, although I'd be curious how I could have
> gotten into this situation.


If PostgreSQL is not told to shutdown then it will not delete the pid
file itself.

Charlie
--
Charlie Clark
Helmholtzstr. 20
Düsseldorf
D- 40215
Tel: +49-211-938-5360
GSM: +49-178-782-6226