We're happy to see the problem resolved on your end. :-)
Thanks & Regards,
EnterpriseDB INDIA: Enterprise Postgres Company<http://www.enterprisedb.com>
On Mon, Sep 27, 2010 at 8:57 PM, Llewellyn, Mark (ADP DSI) <
> 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 password
> was reset.
> Problem now resolved.
> Many thanks
> Mark Llewellyn
> *From:* Ashesh Vashi [mailto:ashesh(dot)vashi(at)enterprisedb(dot)com]
> *Sent:* 17 September 2010 04:51
> *To:* Llewellyn, Mark (ADP DSI)
> *Cc:* pgsql-bugs(at)postgresql(dot)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
> 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>
> 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
> The postgresql-9.0 service is showing as *not running* in pgAdmin 3 1.12
> 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:
> This message and any attachments are intended only for the use of the
> addressee and may contain information that is privileged and confidential.
> If the reader of the message is not the intended recipient or an authorized
> representative of the intended recipient, you are hereby notified that any
> dissemination of this communication is strictly prohibited. If you have
> received this communication in error, please notify us immediately by e-mail
> and delete the message and any attachments from your system.
In response to
pgsql-hackers by date
|Next:||From: Guillaume Du Pasquier||Date: 2010-09-27 16:56:49|
|Subject: Re: client socket TIME_WAIT state after PQfinish|
|Previous:||From: Robert Haas||Date: 2010-09-27 16:38:27|
|Subject: Re: Improving prep_buildtree used in VPATH builds|
pgsql-bugs by date
|Next:||From: Robert Haas||Date: 2010-09-27 17:08:45|
|Subject: Re: BUG #5650: Postgres service showing as stopped when in
fact it is running|
|Previous:||From: Kevin Grittner||Date: 2010-09-27 16:30:35|
|Subject: Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)|