Re: [GENERAL] could not access file "$libdir/pg_buffercache": No such file or directory

2011-09-30 Thread Albe Laurenz
Royce Ausburn wrote: > I'm in the process of testing out Postgres 9.0 for production use. I've been using it for development > on my mac, a build from EnterpriseDB. We've just installed a 9.0.5 on an Ubuntu (Ubuntu 10.04.3 LTS) > machine from a backport from lucid. There's an existing 8.4.8 postg

Re: [GENERAL] could not access file "$libdir/pg_buffercache": No such file or directory

2011-09-29 Thread Magnus Hagander
On Fri, Sep 30, 2011 at 04:45, Royce Ausburn wrote: > I'm in the process of testing out Postgres 9.0 for production use.  I've been > using it for development on my mac, a build from EnterpriseDB.  We've just > installed a 9.0.5 on an Ubuntu (Ubuntu 10.04.3 LTS) machine from a backport > from l

Re: [GENERAL] could not access file "$libdir/pg_buffercache": No such file or directory

2011-09-29 Thread Venkat Balaji
One way could be - If the restore you are performing is not very big. Then pg_dump can be taken with "--inserts" and we can remove "create function " lines from the output file and restore. Thanks VB On Fri, Sep 30, 2011 at 10:59 AM, Venkat Balaji wrote: > I had faced the same problem 2 days ea

Re: [GENERAL] could not access file "$libdir/pg_buffercache": No such file or directory

2011-09-29 Thread Venkat Balaji
I had faced the same problem 2 days earlier and that was for "pg_freespacemap" contrib module. I did not know the way to ignore these functions and installed THE contrib modules and restored. It worked ! I am also looking for a way to ignore these functions. Thanks VB On Fri, Sep 30, 2011 at 8:

[GENERAL] could not access file "$libdir/pg_buffercache": No such file or directory

2011-09-29 Thread Royce Ausburn
I'm in the process of testing out Postgres 9.0 for production use. I've been using it for development on my mac, a build from EnterpriseDB. We've just installed a 9.0.5 on an Ubuntu (Ubuntu 10.04.3 LTS) machine from a backport from lucid. There's an existing 8.4.8 postgres install also on tha

[GENERAL] could not access file $libdir...

2004-12-20 Thread Sim Zacks
I am using PG version 8.0 beta 1 and I have run into some problems. I have 2 RedHat 8 servers running the same PG version, I built them both from source, and I believe I used the same configure parameters. I have a database on one of them and want to move it to the second one, but it is not workin

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

2004-07-06 Thread Tom Lane
=?iso-8859-1?q?Clodoaldo=20Pinto=20Neto?= <[EMAIL PROTECTED]> writes: > The postgresql was installed by anaconda installer > during the box setup. Perhaps you forgot to include the postgresql-pl package? IIRC that is where most of the plXXX.so files are distributed. regar

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

2004-07-06 Thread Clodoaldo Pinto Neto
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 >

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

2004-07-05 Thread mike g
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 ve

[GENERAL] could not access file "$libdir/plpython" when restoring

2004-07-05 Thread Clodoaldo Pinto Neto
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 ge