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/
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 |