Skip site navigation (1) Skip section navigation (2)

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

From: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
To: "Llewellyn, Mark (ADP DSI)" <mark_llewellyn(at)adp(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>, Sujeet Rajguru <sujeet(dot)rajguru(at)enterprisedb(dot)com>
Subject: Re: BUG #5650: Postgres service showing as stopped when in fact it is running
Date: 2010-09-27 16:44:47
Message-ID: AANLkTi=Q6oHoA_S+M91_Kgp8ii7gFDg9zad=_Ogqbmv1@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
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.
>

In response to

Responses

pgsql-hackers by date

Next:From: Guillaume Du PasquierDate: 2010-09-27 16:56:49
Subject: Re: client socket TIME_WAIT state after PQfinish
Previous:From: Robert HaasDate: 2010-09-27 16:38:27
Subject: Re: Improving prep_buildtree used in VPATH builds

pgsql-bugs by date

Next:From: Robert HaasDate: 2010-09-27 17:08:45
Subject: Re: BUG #5650: Postgres service showing as stopped when in fact it is running
Previous:From: Kevin GrittnerDate: 2010-09-27 16:30:35
Subject: Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group