Hi all I'm new to PostGIS and have a question about restoring a PostGIS dump into a new created PostGIS database.
The dump was made in a database system using PostGIS version 1.4. It was given to me and I now tried to restore it in my database system (PostgreSQL 9.2, PostGIS 2.0, OS: Windows 7 64 bit). I followed the instructions given in http://postgis.refractions.net/documentation/manual-2.0/postgis_installation.html#create_new_db_extensions and then tried to restore the dump by the following commands: pg_restore -U postgres -f temp_dump myDump.backup psql -U postgres -L logging_output myDatabase < temp_dump As result I get errors like ERROR: could not access file "$libdir/postgis-1.4": No such file or directory By the help of my logging_output file, I could detect the corresponding command: CREATE FUNCTION st_box2d_in(cstring) RETURNS box2d LANGUAGE c IMMUTABLE STRICT AS '$libdir/postgis-1.4', 'BOX2DFLOAT4_in'; As mentioned, I use PostGIS 2.0, so of course $libdir/postgis-1.4 doesn't exist. How can I solve this problem? Thank you! Christoph -- View this message in context: http://postgis.17.n6.nabble.com/Question-about-restoring-a-dump-tp5000887.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users