[postgis-users] Problem moving database
Michael A. Peters
mpeters at shastaherps.org
Fri Sep 9 14:00:01 PDT 2011
Old server:
- 32 bit CentOS 5.6
- postgresql-8.4.4-2PGDG.el5
- postgresql-server-8.4.4-2PGDG.el5
- postgis-1.3.6-1.rhel5
New server:
- 64 bit CentOS 6
- postgresql-8.4.7-1.el6_0.1.x86_64
- postgresql-server-8.4.7-1.el6_0.1.x86_64
- postgis-1.5.1-1.el6.x86_64
Dump Method:
pg_dump -Fc shastaherps > shastaherps.dump
Restore Method: (as postgres user)
sh /usr/share/postgis/postgis_restore.pl postgis-64.sql shastaherps
shastaherps.dump -E=UNICODE > restore.log
Problems:
Console full of error - IE
ERROR: language "plpgsql" already exists
ERROR: function st_histogram2d_in(cstring) does not exist
ERROR: could not access file "/usr/lib/pgsql/liblwgeom": No such file
or directory
ERROR: function public.asukml(geometry, integer, integer) does not exist
ERROR: could not access file "/usr/lib/pgsql/liblwgeom": No such file
or directory
ERROR: function public.asukml(geometry, integer) does not exist
ERROR: could not access file "/usr/lib/pgsql/liblwgeom": No such file
or directory
ERROR: function public.asukml(geometry) does not exist
ERROR: could not access file "/usr/lib/pgsql/liblwgeom": No such file
or directory
ERROR: function public.box2d_contain(box2d, box2d) does not exist
ERROR: could not access file "/usr/lib/pgsql/liblwgeom": No such file
or directory
ERROR: function public.box2d_contained(box2d, box2d) does not exist
ERROR: could not access file "/usr/lib/pgsql/liblwgeom": No such file
or directory
etc.
ERROR: function public.transform_geometry(geometry, text, text,
integer) does not exist
ERROR: function geom_accum(geometry[], geometry) does not exist
ERROR: aggregate public.geomunion(geometry) does not exist
-bash-4.1$ yum provides '/usr/lib/pgsql/liblwgeom'
Loaded plugins: fastestmirror
No Matches found
-=-=-
Any suggestions?
More information about the postgis-users
mailing list