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

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.

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/

=?iso-8859-1?q?Clodoaldo=20Pinto=20Neto?= <clodoaldo_pinto@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

Installing postgres-pl made it work. Also installed
postgres-python.

Thank You,
Clodoaldo Pinto

--- Tom Lane <tgl@sss.pgh.pa.us> escreveu: >
=?iso-8859-1?q?Clodoaldo=20Pinto=20Neto?=

<clodoaldo_pinto@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

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