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

We're happy to see the problem resolved on your end. :-)

--
Thanks & Regards,

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

*http://www.linkedin.com/in/asheshvashi*<http://www.linkedin.com/in/asheshvashi>

On Mon, Sep 27, 2010 at 8:57 PM, Llewellyn, Mark (ADP DSI) <
mark_llewellyn(at)adp(dot)com> wrote:

> 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
> 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
>
>
>
> ------------------------------
> 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.
>