could not access file "$libdir/plpython" when restoring

[Clodoaldo Pinto Neto]

Hi all,

I'm restoring a database from 7.3.4 FC1 to 7.4.2 FC2:

[cpn@s1 bak]$ pg_restore -d KakaoStats KakaoStats.dump
pg_restore: [compressão de arquivo (banco de dados)]
could not execute query: ERROR: could not access file
"$libdir/plpython": No such file or directory

The dump was generated with the command:

[cpn@s00 bak]$ pg_dump -Fc KakaoStats >
KakaoStats.dump

What value should $libdir contain? How to make it
permantent?

Tried createlang:

[cpn@s1 bak]$ createlang --echo plpythonu KakaoStats
SELECT oid FROM pg_language WHERE lanname =
'plpythonu';
SELECT oid FROM pg_proc WHERE proname =
'plpython_call_handler' AND prorettype = (SELECT oid
FROM pg_type WHERE typname = 'language_handler') AND
pronargs = 0;
CREATE FUNCTION "plpython_call_handler" () RETURNS
language_handler AS '$libdir/plpython' LANGUAGE C;
CREATE LANGUAGE "plpythonu" HANDLER
"plpython_call_handler";
createlang: instalação da linguagem falhou: ERROR:
could not access file "$libdir/plpython": No such file
or directory

Regards,
Clodoaldo Pinto

__________________________________________________ _____
Yahoo! Mail agora com 100MB, anti-spam e antivírus grátis!
http://br.info.mail.yahoo.com/

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

http://archives.postgresql.org

[mike g]

Seems your FC2 box did not have the python language support compiled
into the version of postgresql that was installed on that box or
possibly not installed in the template1 database so it would be
available to any other database created in your FC2.

I do believe python is included in the rpm versions of postgresql that
are put on the mirrors. Did you compile it from source? If so
recompile and add the python option.

On Mon, 2004-07-05 at 20:33, Clodoaldo Pinto Neto wrote:

Hi all,

I'm restoring a database from 7.3.4 FC1 to 7.4.2 FC2:

[cpn@s1 bak]$ pg_restore -d KakaoStats KakaoStats.dump
pg_restore: [compressão de arquivo (banco de dados)]
could not execute query: ERROR: could not access file
"$libdir/plpython": No such file or directory

The dump was generated with the command:

[cpn@s00 bak]$ pg_dump -Fc KakaoStats >
KakaoStats.dump

What value should $libdir contain? How to make it
permantent?

Tried createlang:

[cpn@s1 bak]$ createlang --echo plpythonu KakaoStats
SELECT oid FROM pg_language WHERE lanname =
'plpythonu';
SELECT oid FROM pg_proc WHERE proname =
'plpython_call_handler' AND prorettype = (SELECT oid
FROM pg_type WHERE typname = 'language_handler') AND
pronargs = 0;
CREATE FUNCTION "plpython_call_handler" () RETURNS
language_handler AS '$libdir/plpython' LANGUAGE C;
CREATE LANGUAGE "plpythonu" HANDLER
"plpython_call_handler";
createlang: instalação da linguagem falhou: ERROR:
could not access file "$libdir/plpython": No such file
or directory

Regards,
Clodoaldo Pinto

__________________________________________________ _____
Yahoo! Mail agora com 100MB, anti-spam e antivÃ*rus grátis!
http://br.info.mail.yahoo.com/

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

http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Clodoaldo Pinto Neto]

The postgresql was installed by anaconda installer
during the box setup.

Tried to install to template1 as postgres with no
success:

bash-2.05b$ createlang plpythonu template1
createlang: instalação da linguagem falhou: ERROR:
could not access file "$libdir/plpython": No such file
or directory

Seems your FC2 box did not have the python language
support compiled
into the version of postgresql that was installed on
that box or
possibly not installed in the template1 database so
it would be
available to any other database created in your FC2.
I do believe python is included in the rpm versions
of postgresql that
are put on the mirrors. Did you compile it from
source? If so
recompile and add the python option.

On Mon, 2004-07-05 at 20:33, Clodoaldo Pinto Neto
wrote:

Hi all,

I'm restoring a database from 7.3.4 FC1 to 7.4.2

FC2:

[cpn@s1 bak]$ pg_restore -d KakaoStats

KakaoStats.dump

pg_restore: [compressão de arquivo (banco de

dados)]

could not execute query: ERROR: could not access

file

"$libdir/plpython": No such file or directory

The dump was generated with the command:

[cpn@s00 bak]$ pg_dump -Fc KakaoStats >
KakaoStats.dump

What value should $libdir contain? How to make it
permantent?

Tried createlang:

[cpn@s1 bak]$ createlang --echo plpythonu

KakaoStats

SELECT oid FROM pg_language WHERE lanname =
'plpythonu';
SELECT oid FROM pg_proc WHERE proname =
'plpython_call_handler' AND prorettype = (SELECT

oid

FROM pg_type WHERE typname = 'language_handler')

AND

pronargs = 0;
CREATE FUNCTION "plpython_call_handler" () RETURNS
language_handler AS '$libdir/plpython' LANGUAGE C;
CREATE LANGUAGE "plpythonu" HANDLER
"plpython_call_handler";
createlang: instalação da linguagem falhou:

ERROR:

could not access file "$libdir/plpython": No such

file

or directory

Regards,
Clodoaldo Pinto

__________________________________________________ _____

Yahoo! Mail agora com 100MB, anti-spam e

antivÃ*rus grátis!

http://br.info.mail.yahoo.com/

---------------------------(end of

broadcast)---------------------------

TIP 6: Have you searched our list archives?

http://archives.postgresql.org

__________________________________________________ _____
Yahoo! Mail agora com 100MB, anti-spam e antivírus grátis!
http://br.info.mail.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[Tom Lane]

=?iso-8859-1?q?Clodoaldo=20Pinto=20Neto?= <cl*************@yahoo.com.br> writes:

The postgresql was installed by anaconda installer
during the box setup.

Perhaps you forgot to include the postgresql-pl package? IIRC that
is where most of the plXXX.so files are distributed.

regards, tom lane

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