2009/9/29 Yaming Gu <yaming...@w-oasis.com>: > Hi, Robert, > > According to your recommendations, I tried to load plperu, almost the same > error messages have shown: > > D:\Program Files\Postgresql\8.3\bin>createlang -U postgres plperlu example > > Password: > > createlang: language installation failed: server closed the connection > unexpectedly > > This probably means the server terminated abnormally > > before or while processing the request. > > The following is pg_log message: > > 2009-09-29 14:28:07 HKT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > > 2009-09-29 14:28:44 HKT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > > 2009-09-29 14:28:50 HKT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > > 2009-09-29 14:28:53 HKT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > > Substitution pattern not terminated at line 1. > > 2009-09-29 14:28:55 HKT LOG: Server process (PID 3596) exited, exit code > 255 > > 2009-09-29 14:28:55 HKT LOG: terminating any other active server processes > > 2009-09-29 14:28:55 HKT WARNING: terminating connection because of crash of > another server process > > 2009-09-29 14:28:55 HKT DETAIL: The postmaster has commanded this server > process to roll back the current transaction and exit, because another > server process exited abnormally and possibly corrupted shared memory. > > 2009-09-29 14:28:55 HKT HINT: In a moment you should be able to reconnect > to the database and repeat your command. > > 2009-09-29 14:28:55 HKT WARNING: terminating connection because of crash of > another server process > > 2009-09-29 14:28:55 HKT DETAIL: The postmaster has commanded this server > process to roll back the current transaction and exit, because another > server process exited abnormally and possibly corrupted shared memory. > > 2009-09-29 14:28:55 HKT HINT: In a moment you should be able to reconnect > to the database and repeat your command. > > 2009-09-29 14:28:55 HKT LOG: all server processes terminated; > reinitializing > > 2009-09-29 14:28:56 HKT FATAL: pre-existing shared memory block is still in > use > > 2009-09-29 14:28:56 HKT HINT: Check if there are any old server processes > still running, and terminate them. > > > > I wonder about the line of “terminating connection because of crash of > another server process”. I have done nothing else except starting up > postgresql service.
Well, that's a normal message when something crashes. The question is what's making it crash. Have you tried removing plugin_debugger.dll from the equation? Have you tried a fresh PostgreSQL install? Something's obviously different in your installation than elsewhere. ...Robert -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs