From: | "Anibal David Acosta" <aa(at)devshock(dot)com> |
---|---|
To: | "'Craig Ringer'" <ringerc(at)ringerc(dot)id(dot)au>, "'Vincent Dautremont'" <vincent(at)searidgetech(dot)com> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Windows Services and Postgresql 9.1.3 |
Date: | 2012-09-18 01:27:20 |
Message-ID: | 001201cd953c$c16f84e0$444e8ea0$@devshock.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Yes, is a Bug, sometimes in some circumstances pg_ctl go down but postgres
server still running.
You can easily reproduce.
Go to "task manager", kill the process "pg_ctl" (simulate some kind of crash
or something else).
Now go to services management and try to start again. Start command will
through an error because pg_ctl can't start database because is already
started.
Due to this bug I always use the pg_ctl command directly and not the windows
service.
Running pg_ctl command from command prompt show that postgres server is
running, but windows service show stopped and is not possible to start again
from windows service UI
Maybe a resolution of this is that pg_ctl ignore the start call from windows
(just success it) when it is already running.
Regards
-----Mensaje original-----
De: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] En nombre de Craig Ringer
Enviado el: lunes, 17 de septiembre de 2012 12:43 a.m.
Para: Vincent Dautremont
CC: pgsql-admin(at)postgresql(dot)org
Asunto: Re: [ADMIN] Windows Services and Postgresql 9.1.3
On 09/12/2012 04:48 AM, Vincent Dautremont wrote:
> For example, after the server had rebooted, I would stop the service
> from services.msc Windows then reports it as stopped but I can still
> see that the database is running, and can use it.
Check in the process monitor (or, better, with Process Explorer from
Sysinternals) to see what user the `postgres.exe` processes are running as.
> When I would start the service again, I would end up with a timeout
> waiting for the service to be started. When in fact the database was
> always running.
>
> Anyone had that bug/problem before ?
Nope. Sounds completely crazy. More info needed, though.
--
Craig Ringer
--
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-09-18 01:36:34 | Re: Linux: ps output shows multiple instances of PostgreSQL running on the same port |
Previous Message | David Throckmorton | 2012-09-18 00:38:48 | Linux: ps output shows multiple instances of PostgreSQL running on the same port |
From | Date | Subject | |
---|---|---|---|
Next Message | Anibal David Acosta | 2012-09-18 01:42:52 | Re: Windows Services and Postgresql 9.1.3 |
Previous Message | Jeff Janes | 2012-09-18 00:19:06 | Re: Index creation takes more time? |