[postgis-tickets] migrate the postgis db to server 1.5 to 2.1

[rajat gupta]

 postgis-tickets at lists.osgeo.org.

Hi,

I need to migrate the postgis db to server 1.5 to 2.1 on new hardware.

1) I have installed the postgres9.3 and postgis2.1 in new centos server .
2) I took db dump on postgis server 1.5 vis pg_dump command.
3) i can see the below on sql file
CREATE FUNCTION box3d_in(cstring) RETURNS box3d
    LANGUAGE c IMMUTABLE STRICT
    AS '$libdir/postgis-1.5', 'BOX3D_in';

4) when i'm restoring the db file on postgis server 2.1 i am getting error

"ERROR: could not access file "$libdir/postgis-1.5": No such file or
directory"


I can't figure out how to fix this.

/Rajat

-- 

*Rajat Gupta *
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-tickets/attachments/20140825/3f4dc085/attachment.html>