Re: [GENERAL] could not access file "$libdir/pg_buffercache": No such file or directory
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 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@fishy:~$ createdb test > royce@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? Your theory sounds correct since there is a contrib "pg_buffercache" and the error message indicates that the shared object cannot be found. The best solution would be to drop FUNCTION pg_buffercache_pages() and VIEW pg_buffercache in the original database before dumping. That way you can be sure that nothing else in the database depends on these objects. You can always reinstall the contrib if you need it. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] could not access file "$libdir/pg_buffercache": No such file or directory
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 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@fishy:~$ createdb test > royce@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) Yes. > - Is there some simple way I can prevent these views from being emitted as > part of the dump? Not easily, not in 9.0. Once you upgrade to 9.1 and upgrade them to extensions, the problem should be much easier.. > - Is there some simple way I can prevent these views from being restored from > a dump that contains them? Not really. > - Otherwise, how can I purge these contrib modules from my laptop? There is an uninstall script for them. it should be next to where your install script is (usually in share/contrib, but I'm not sure where the edb installer puts it on the mac). It's called uninstall_pg_cuffercache.sql. Run that in the old database and it should drop all the required objects. > Otherwise, if my theory is incorrect, any hints as to what it might be? You can also install the -contrib DEB package on your Ubuntu box, and then you will have the required libraries, and it will recreate the functions and views correctly. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 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 " 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 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 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@fishy:~$ createdb test >> royce@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@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > >
Re: [GENERAL] could not access file "$libdir/pg_buffercache": No such file or directory
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 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@fishy:~$ createdb test > royce@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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
[GENERAL] could not access file "$libdir/pg_buffercache": No such file or directory
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@fishy:~$ createdb test royce@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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general