could not access file "$libdir/plpython" when restoring - Mailing list pgsql-general

From Clodoaldo Pinto Neto
Subject could not access file "$libdir/plpython" when restoring
Date
Msg-id 20040706013351.67562.qmail@web40906.mail.yahoo.com
Whole thread Raw
Responses Re: could not access file "$libdir/plpython" when
List pgsql-general
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/

pgsql-general by date:

Previous
From:
Date:
Subject: SUBSTRING for a regular expression
Next
From: mike g
Date:
Subject: Re: server closed the connection unexpectedly