Thread: BUG #2216: Cannot unregister service

BUG #2216: Cannot unregister service

From
"Taworn T."
Date:
The following bug has been logged online:

Bug reference:      2216
Logged by:          Taworn T.
Email address:      taworn@yahoo.com
PostgreSQL version: 8.1.2
Operating system:   Windows XP
Description:        Cannot unregister service
Details:

I've install PGSQL 8.1 as Windows service, using following command line:

"C:\Program Files\PostgreSQL-8.1\bin\pg_ctl.exe" register -N PostgreSQL81 -D
"<path_to_data>" -U Postgres

The result is success and I can use PGSQL as usual.

But when I uninstall service using following command line:

"C:\Program Files\PostgreSQL-8.1\bin\pg_ctl.exe" unregister -N PostgreSQL81

pg_ctl.exe is crashed!! with error reporting (to Microsoft) screen:

"pg_ctl.exe has encountered a problem and needs to close.  We are sorry for
the inconvenience."

And the PGSQL service remains and can still be used.

Please note that version 8.0 does not has this bug.
I've encountered this problem when migrating to 8.1.
I've also recreate database cluster with version 8.1 but it has the same
error.

The version I've downloaded is
postgresql-8.1.2-1-binaries-no-installer.zip.

Regards,
Taworn T.

PS: Sorry about my poor English Y_Y

Re: BUG #2216: Cannot unregister service

From
"Magnus Hagander"
Date:
> The following bug has been logged online:
>=20
> Bug reference:      2216
> Logged by:          Taworn T.
> Email address:      taworn@yahoo.com
> PostgreSQL version: 8.1.2
> Operating system:   Windows XP
> Description:        Cannot unregister service
> Details:=20
>=20
> I've install PGSQL 8.1 as Windows service, using following=20
> command line:
>=20
> "C:\Program Files\PostgreSQL-8.1\bin\pg_ctl.exe" register -N=20
> PostgreSQL81 -D "<path_to_data>" -U Postgres
>=20
> The result is success and I can use PGSQL as usual.
>=20
> But when I uninstall service using following command line:
>=20
> "C:\Program Files\PostgreSQL-8.1\bin\pg_ctl.exe" unregister=20
> -N PostgreSQL81
>=20
> pg_ctl.exe is crashed!! with error reporting (to Microsoft) screen:
>=20
> "pg_ctl.exe has encountered a problem and needs to close.  We=20
> are sorry for the inconvenience."

This is a known bug that's fixed in CVS:
http://archives.postgresql.org/pgsql-committers/2006-01/msg00220.php

The workaround is to specify the data directory, e.g.
pg_ctl -D "c:\program files\postgresql-8.1\data" unregister -N
PostgreSQL81

//Magnus