From: | "Yaming Gu" <yaming(dot)gu(at)w-oasis(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Encounter shared memory error when running createlang command! |
Date: | 2009-09-24 03:44:06 |
Message-ID: | 4C13DA21211F445AA94D1C1A4887313B@SH.WOASIS.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi, List,
Because my previous mail contains some Chinese character, now I modified
it, the whole problem is described as below:
I need to create language Pl/Perl. I have checked all dependencies of
plperl.dll and all is ok.
Next:
D:\Program Files\Postgresql\bin>createlang -U postgres -e plperl example
(example is my dbname)
Password:
SELECT oid FROM pg_catalog.pg_language WHERE lanname = 'plperl';
CREATE LANGUAGE "plperl";
createlang: language installation failed: server closed the connection
unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
And pg_log is :
2009-09-24 10:50:55 HKT LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"
2009-09-24 10:50:59 HKT LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"
Substitution pattern not terminated at line 1.
2009-09-24 10:51:01 HKT LOG: Server process (PID 1640) exited, exit code
255
2009-09-24 10:51:01 HKT LOG: terminating any other active server processes
2009-09-24 10:51:01 HKT LOG: all server processes terminated;
reinitializing
2009-09-24 10:51:02 HKT FATAL: pre-existing shared memory block is still in
use
2009-09-24 10:51:02 HKT HINT: Check if there are any old server processes
still running, and terminate them.
Then unsurprised, I found pgsql-8.3 service has stopped. But then I can
start up it successfully.
Thank you for any advice in advance.
I have been kept on it for two days..
BR
Lucy Gu
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2009-09-24 04:48:02 | Re: Encounter shared memory error when running createlang command! |
Previous Message | Kaelten | 2009-09-24 03:11:33 | Re: BUG #5077: Corrupted Table |