If you can [1] use postgis_restore rather than pg_restore, as described in the Hard Upgrade section of the manual: http://www.postgis.net/documentation/manual-2.0SVN/postgis_installation.html#hard_upgrade
[1] you can use it only if your dump was made using custom format (-Fc switch to pg_dump) --strk; http://www.cartodb.com - Map, analyze and build applications with your data ~~ http://strk.keybit.net On Wed, Oct 31, 2012 at 07:40:15AM -0700, lynx86 wrote: > 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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
