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

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

From
"Mark Llewellyn"
Date:
The following bug has been logged online:

Bug reference:      5650
Logged by:          Mark Llewellyn
Email address:      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.

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

From
Robert Haas
Date:
On Thu, Sep 9, 2010 at 12:22 PM, Mark Llewellyn <mark_llewellyn@adp.com> wr=
ote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05650
> Logged by: =A0 =A0 =A0 =A0 =A0Mark Llewellyn
> Email address: =A0 =A0 =A0mark_llewellyn@adp.com
> PostgreSQL version: 9.0 RC1
> Operating system: =A0 Windows XP
> Description: =A0 =A0 =A0 =A0Postgres service showing as stopped when in f=
act 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.

Maybe this is a dumb question, but how did you start the service?

And applying the good old Windows troubleshooting meme...  if you
reboot, does that fix it?

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

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

From
Ashesh Vashi
Date:
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@adp.com>wrote:

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

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

From
Ashesh Vashi
Date:
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@adp.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.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
> 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@adp.com>
> wrote:
>
>
> The following bug has been logged online:
>
> Bug reference:      5650
> Logged by:          Mark Llewellyn
> Email address:      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)
> 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.
>

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

From
Robert Haas
Date:
On Mon, Sep 27, 2010 at 12:44 PM, Ashesh Vashi <
ashesh.vashi@enterprisedb.com> wrote:

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

However, it doesn't seem that we've actually done anything about the
underlying issue with pg_ctl.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

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

From
"Llewellyn, Mark (ADP DSI)"
Date:
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.

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

From
Bruce Momjian
Date:
Robert Haas wrote:
> On Mon, Sep 27, 2010 at 12:44 PM, Ashesh Vashi <
> ashesh.vashi@enterprisedb.com> wrote:
>
> > We're happy to see the problem resolved on your end. :-)--
> >
>
> However, it doesn't seem that we've actually done anything about the
> underlying issue with pg_ctl.

I will look at that in the next few weeks.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +