Re: BUG #5650: Postgres service showing as stopped when in fact it is running

Hi Mark,

On of my college (Sujeet) has found a way to reproduce the same behaviour.
1. Installed PG 9.0 on Win XP SP3
2. Stop the Postgresql-9.0 service from service manager console
3. Create pgpass.conf in postgres (service account) user's profile with an
incorrect password deliberately.
(Refer: http://www.postgresql.org/docs/8.4/interactive/libpq-pgpass.html)
4. Now start the postgresql-9.0 service, it will return an error and the
status
shows stopped
5. However i could connect to the psql shell and get the prompt which means
the server is running.

So, please check if pgpass.conf file exists in service account (postgres)
user's %APPDATA%\postgresql directory with wrong password.

--
Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise Postgres Company<http://www.enterprisedb.com>

On Thu, Sep 9, 2010 at 9:52 PM, Mark Llewellyn <mark_llewellyn(at)adp(dot)com>wrote:

>
> The following bug has been logged online:
>
> Bug reference: 5650
> Logged by: Mark Llewellyn
> Email address: mark_llewellyn(at)adp(dot)com
> PostgreSQL version: 9.0 RC1
> Operating system: Windows XP
> Description: Postgres service showing as stopped when in fact it is
> running
> Details:
>
> The postgresql-9.0 service is showing as *not running* in pgAdmin 3 1.12
> RC1
> and as *stopped* in the Windows services list, although the database is
> actually running and I can connect to it and create databases, tables etc.
> It also shows multiple postgresql tasks in Windows task manager.
> However, because Windows XP is not aware that the postgresql-9.0 service is
> running it is not possible to stop the service.
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>