[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Question about restoring a dump
From:       Sandro Santilli <strk () keybit ! net>
Date:       2012-10-31 15:00:28
Message-ID: 20121031150028.GB22181 () gnash
[Download RAW message or body]

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


[prev in list] [next in list] [prev in thread] [next in thread]