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

2011-09-30 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 buffercache lines from the output file and restore. Thanks VB On Fri, Sep 30, 2011 at 10:59 AM, Venkat Balaji venkat.bal...@verse.inwrote: I had

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

2011-09-30 Thread Magnus Hagander
On Fri, Sep 30, 2011 at 04:45, Royce Ausburn royce...@inomial.com 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

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

[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

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