2009/9/29 Yaming Gu <yaming.gu@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
