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

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

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

> 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: [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/
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
>




_______________________________________________________
Yahoo! Mail agora com 100MB, anti-spam e antivírus grátis!
http://br.info.mail.yahoo.com/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Markus Wollny 2004-07-06 10:18:58 ./configure --with-java fails
Previous Message Alberto Cabello Sanchez 2004-07-06 07:23:28 Grants on rules