[postgis-users] Question about restoring a dump

[Sandro Santilli]

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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users