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: > > > > [EMAIL PROTECTED] 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: > > > > [EMAIL PROTECTED] bak]$ pg_dump -Fc KakaoStats > > > KakaoStats.dump > > > > What value should $libdir contain? How to make it > > permantent? > > > > Tried createlang: > > > > [EMAIL PROTECTED] 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/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
