Re: could not access file "$libdir/plpython" when

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(at)s1 bak]$ pg_restore -d KakaoStats KakaoStats.dump
> pg_restore: [compresso 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: instalao 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 antivrus grtis!
> http://br.info.mail.yahoo.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org