[postgis-users] Question about restoring a dump

[lynx86]

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.