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

Hi Ashesh

Yes, this appears to be the issue that the password in the pgpass.conf file=
 for the postgres user had not been changed when the windows account passwo=
rd was reset.

Problem now resolved.

Many thanks
Mark Llewellyn

________________________________
From: Ashesh Vashi [mailto:ashesh.vashi@enterprisedb.com]
Sent: 17 September 2010 04:51
To: Llewellyn, Mark (ADP DSI)
Cc: pgsql-bugs@postgresql.org; Sujeet Rajguru
Subject: Re: [BUGS] 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 st=
atus
   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) u=
ser'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@adp.com<mail=
to:mark_llewellyn@adp.com>> wrote:

The following bug has been logged online:

Bug reference:      5650
Logged by:          Mark Llewellyn
Email address:      mark_llewellyn@adp.com<mailto:mark_llewellyn@adp.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@postgresql.org<mailto:pgsql-bu=
gs@postgresql.org>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs



This message and any attachments are intended only for the use of the addre=
ssee and may contain information that is privileged and confidential. If th=
e reader of the message is not the intended recipient or an authorized repr=
esentative of the intended recipient, you are hereby notified that any diss=
emination of this communication is strictly prohibited. If you have receive=
d this communication in error, please notify us immediately by e-mail and d=
elete the message and any attachments from your system.