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
[color=blue]
> 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:[color=green]
> > Hi all,
> >
> > I'm restoring a database from 7.3.4 FC1 to 7.4.2[/color]
> FC2:[color=green]
> >
> > [cpn@s1 bak]$ pg_restore -d KakaoStats[/color]
> KakaoStats.dump[color=green]
> > pg_restore: [compressão de arquivo (banco de[/color]
> dados)][color=green]
> > could not execute query: ERROR: could not access[/color]
> file[color=green]
> > "$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[/color]
> KakaoStats[color=green]
> > SELECT oid FROM pg_language WHERE lanname =
> > 'plpythonu';
> > SELECT oid FROM pg_proc WHERE proname =
> > 'plpython_call_handler' AND prorettype = (SELECT[/color]
> oid[color=green]
> > FROM pg_type WHERE typname = 'language_handler')[/color]
> AND[color=green]
> > 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:[/color]
> ERROR:[color=green]
> > could not access file "$libdir/plpython": No such[/color]
> file[color=green]
> > or directory
> >
> > Regards,
> > Clodoaldo Pinto
> >
> >
> >
> >
> >
> >[/color]
>[/color]
__________________________________________________ _____[color=blue][color=green]
> > Yahoo! Mail agora com 100MB, anti-spam e[/color]
> antivÃ*rus grátis![color=green]
> >
http://br.info.mail.yahoo.com/
> >
> > ---------------------------(end of[/color]
> broadcast)---------------------------[color=green]
> > TIP 6: Have you searched our list archives?
> >
> >
http://archives.postgresql.org[/color]
>[/color]
__________________________________________________ _____
Yahoo! Mail agora com 100MB, anti-spam e antivírus grátis!
http://br.info.mail.yahoo.com/
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org 
