BUG #2216: Cannot unregister service

Started by Taworn T.about 20 years ago2 messagesbugs
Jump to latest
#1Taworn T.
taworn@yahoo.com

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

#2Magnus Hagander
magnus@hagander.net
In reply to: Taworn T. (#1)
Re: BUG #2216: Cannot unregister service

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

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