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

From: Clodoaldo Pinto Neto <clodoaldo_pinto(at)yahoo(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: could not access file "$libdir/plpython" when restoring
Date: 2004-07-06 01:33:51
Message-ID: 20040706013351.67562.qmail@web40906.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

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

[cpn(at)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(at)s00 bak]$ pg_dump -Fc KakaoStats >
KakaoStats.dump

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

Tried createlang:

[cpn(at)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/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mike g 2004-07-06 02:50:52 Re: server closed the connection unexpectedly
Previous Message btober 2004-07-06 00:40:34 SUBSTRING for a regular expression