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

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(dot)balaji(at)verse(dot)in>wrote:

> 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:15 AM, Royce Ausburn <royce(dot)ml(at)inomial(dot)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
>> backport from lucid. There's an existing 8.4.8 postgres install also on
>> that machine, but as far as I'm aware the debs are set up so you can happily
>> have two installs side by side.
>>
>> I've dumped a test DB from my laptop and attempted to restore it on to the
>> ubuntu machine, but I see errors:
>>
>> royce(at)fishy:~$ createdb test
>> royce(at)fishy:~$ pg_restore -d test --no-owner test_RTR.pgc
>> pg_restore: [archiver (db)] Error while PROCESSING TOC:
>> pg_restore: [archiver (db)] Error from TOC entry 65; 1255 2194102 FUNCTION
>> pg_buffercache_pages() persona
>> pg_restore: [archiver (db)] could not execute query: ERROR: could not
>> access file "$libdir/pg_buffercache": No such file or directory
>> Command was: CREATE FUNCTION pg_buffercache_pages() RETURNS SETOF
>> record
>> LANGUAGE c
>> AS '$libdir/pg_buffercache', 'pg_buffercache_...
>>
>>
>> After looking around a bit, my theory on these errors is that my mac has
>> some contrib module installed that adds views to my test database, and those
>> views have been included in the dump. The contrib module is apparently not
>> installed on the ubuntu machine and hence the restore can't create the
>> views. Is this theory correct? If so:
>>
>> - Can these errors be safely ignored? (not ideal, because I'll miss other,
>> real errors)
>> - Is there some simple way I can prevent these views from being emitted as
>> part of the dump?
>> - Is there some simple way I can prevent these views from being restored
>> from a dump that contains them?
>> - Otherwise, how can I purge these contrib modules from my laptop?
>>
>> Otherwise, if my theory is incorrect, any hints as to what it might be?
>>
>> Cheers!
>>
>> --Royce
>>
>> Mac:
>>
>> version
>>
>> ------------------------------------------------------------------------------------------------------------------------------------
>> PostgreSQL 9.0.4 on x86_64-apple-darwin, compiled by GCC
>> i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5664), 64-bit
>> (1 row)
>>
>>
>> Ubuntu box:
>>
>> version
>>
>> -------------------------------------------------------------------------------------------------------------
>> PostgreSQL 9.0.5 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real
>> (Ubuntu 4.4.3-4ubuntu5) 4.4.3, 64-bit
>> (1 row)
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>