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_llewel...@adp.com>wrote: > > The following bug has been logged online: > > Bug reference: 5650 > Logged by: Mark Llewellyn > Email address: mark_llewel...@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) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs >
