470,815 Members | 1,277 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,815 developers. It's quick & easy.

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

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

Nov 23 '05 #1
3 7260
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

Nov 23 '05 #2
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

Nov 23 '05 #3
=?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

Nov 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Derek Scollon | last post: by
reply views Thread by Chris Albertson | last post: by
reply views Thread by Rich Cullingford | last post: by
1 post views Thread by Nigel J. Andrews | last post: by
reply views Thread by Gerardo Herzig | last post: by
reply views Thread by Gerardo Herzig | last post: by
5 posts views Thread by mechphisto | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.