[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