Обсуждение: BUG #5650: Postgres service showing as stopped when in fact it is running
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.
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
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 >
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. >
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
От
"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 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
От
Bruce Momjian
Дата:
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. +