dbTalk Databases Forums  

[BUGS] BUG #2216: Cannot unregister service

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #2216: Cannot unregister service in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Taworn T.
 
Posts: n/a

Default [BUGS] BUG #2216: Cannot unregister service - 01-27-2006 , 06:53 AM







The following bug has been logged online:

Bug reference: 2216
Logged by: Taworn T.
Email address: taworn (AT) yahoo (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote
  #2  
Old   
Magnus Hagander
 
Posts: n/a

Default Re: [BUGS] BUG #2216: Cannot unregister service - 01-27-2006 , 07:22 AM






Quote:
The following bug has been logged online:
=20
Bug reference: 2216
Logged by: Taworn T.
Email address: taworn (AT) yahoo (DOT) 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...1/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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.