Hi there, I'm trying to upgrade a postgres-8.4 installation using pg_dumpall from a new 9.1.4 install with a subsequent load.
[root@pgsql-9.1.4 ~]# time pg_dumpall -Upostgres -c -h pgsql-8.4.domainname.com | psql -Upostgres It seems to be working fine with the exception of a few Postgis errors thrown at the end of the postgres load. ERROR: could not find function "lwhistogram2d_in" in file "/usr/lib64/pgsql/liblwgeom.so" ERROR: function public.st_histogram2d_in(cstring) does not exist ERROR: could not find function "lwhistogram2d_out" in file "/usr/lib64/pgsql/liblwgeom.so" ERROR: function public.st_histogram2d_out(histogram2d) does not exist ERROR: function st_histogram2d_in(cstring) does not exist ERROR: could not find function "build_lwhistogram2d" in file "/usr/lib64/pgsql/liblwgeom.so" ERROR: function public.build_histogram2d(histogram2d, text, text) does not exist ERROR: PL/pgSQL functions cannot return type histogram2d I've installed the following postgis RPMs: [root@vrsdb03 ~]# rpm -qa |grep postgis91 postgis91-1.5.4-1.rhel6.x86_64 postgis91-utils-1.5.4-1.rhel6.x86_64 As well as doing a necessary compile of the postgis source against my postgresql-9.1.4 install. -------------- Compiler Info ------------- C compiler: gcc -g -O2 C++ compiler: g++ -g -O2 -------------- Dependencies -------------- GEOS config: /usr/bin/geos-config GEOS version: 3.3.5 PostgreSQL config: /usr/pgsql-9.1/bin//pg_config PostgreSQL version: PostgreSQL 9.1.4 PROJ4 version: 47 Libxml2 config: /usr/bin/xml2-config Libxml2 version: 2.7.6 PostGIS debug level: 0 -------- Documentation Generation -------- xsltproc: /usr/bin/xsltproc xsl style sheets: dblatex: convert: I also created a softlink between the /usr/pgsql-9.1/lib standard library to the /usr/lib64/pgsql old library used in the 8.4 install. Making this link seemed to alleviate a few other errors that no longer occur. [root@pgsql-9.1.4 lib64]# pwd /usr/lib64 [root@pgsql-9.1.4 lib64]# ll pgsql lrwxrwxrwx 1 root root 19 Jul 21 13:53 pgsql -> /usr/pgsql-9.1/lib/ [root@pgsql-9.1.4 lib64]# ll pgsql/liblwgeom.so pgsql/postgis-1.5.so lrwxrwxrwx 1 root root 14 Jul 20 08:39 pgsql/liblwgeom.so -> postgis-1.5.so -rwxr-xr-x 1 root root 1975408 Jul 21 19:52 pgsql/postgis-1.5.so Thanks, Jason Mahony Systems Engineer Mobile: 415-471-9131 VerticalResponse, Inc ** Save a tree. Don't print me **
signature.asc
Description: Message signed with OpenPGP using GPGMail
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
