# ./configure --prefix=/usr/local/pgsql --with-python
# make
# make install
# adduser postgres
# mkdir /usr/local/pgsql/data
# chown postgres /usr/local/pgsql/data
# su postgres
% /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
% /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l
/usr/local/pgsql/pg_start.log start
%/usr/local/pgsql/bin/createlang plpython template1
createlang: language installation failed: ERROR: unsupported language
"plpython"
HINT: The supported languages are listed in the pg_pltemplate system
catalog.
%

if I try:
# /usr/local/pgsql/bin/createlang -U postgres plpythonu template1
createlang: language installation failed: ERROR: could not load library
"/usr/l
ocal/pgsql/lib/plpython.so": dlopen (/usr/local/pgsql/lib/plpython.so)
failed: /
usr/local/pgsql/lib/plpython.so: Undefined symbol "pthread_create"
#
is there anything wrong in my configuration???
my box is using freebsd 5.0, python 2.4.2, postgresql-8.1.2
thank you all for your help....
Dedy Styawan


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

On Thu, Feb 02, 2006 at 11:07:41AM +0700, slackman@unika.ac.id wrote:
> # ./configure --prefix=/usr/local/pgsql --with-python
> # make
> # make install
> # adduser postgres
> # mkdir /usr/local/pgsql/data
> # chown postgres /usr/local/pgsql/data
> # su postgres
> % /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
> % /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l
> /usr/local/pgsql/pg_start.log start
> %/usr/local/pgsql/bin/createlang plpython template1
> createlang: language installation failed: ERROR: unsupported language
> "plpython"
> HINT: The supported languages are listed in the pg_pltemplate system
> catalog.
> %
>
> if I try:
> # /usr/local/pgsql/bin/createlang -U postgres plpythonu template1
> createlang: language installation failed: ERROR: could not load library
> "/usr/l
> ocal/pgsql/lib/plpython.so": dlopen (/usr/local/pgsql/lib/plpython.so)
> failed: /
> usr/local/pgsql/lib/plpython.so: Undefined symbol "pthread_create"
> #
> is there anything wrong in my configuration???
> my box is using freebsd 5.0, python 2.4.2, postgresql-8.1.2
> thank you all for your help....
> Dedy Styawan

This is an issue with pthreads. I don't remember the details, but if you
google you should find something. Also take a look at
http://archives.postgresql.org/pgsql...2/msg00143.php .
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org