I am having a problem with a solaris 10 postgresql 9.3 postgis 2.1.3 system. The origin system crashed and all SW was lost. They moved the database files residing on a san to another solaris system 10 that had postgresql installed but no postgis. I don’t have permissions to install postgis nor do they have all the utilities necessary to build it. I tried to do a pg_dump so that I can create the database on a intel platform where I have permissions. When I do pg_dump it terminates with pg_dump: [archiver (db)] query failed: ERROR: could not access file "$libdir/postgis-2.1": No such file or directory pg_dump: [archiver (db)] query was: SELECT a.attnum, a.attname, a.atttypmod, a.attstattarget, a.attstorage, t.typstorage, a.attnotnull, a.atthasdef, a.attisdropped, a.attlen, a.attalign, a.attislocal, pg_catalog.format_type(t.oid, ') AS attfdwoptions FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_type t ON a.atttypid = t.oid WHERE a.attrelid = '6129600'::pg_catalog.oid AND a.attnum > 0::pg_catalog.int2 ORDER BY a.attrelid, a.attnum all the object for postgis are in public but postgres doesn’t show the extension being installed. How can I get around this problem so I dump this database? Thanks |