[postgis-users] postgis-1.5.4 deprecated function in postgresql-9.1.4?

[Jason Mahony]

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 at 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 at 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 at pgsql-9.1.4 lib64]# pwd
/usr/lib64
[root at pgsql-9.1.4 lib64]# ll pgsql
lrwxrwxrwx 1 root root 19 Jul 21 13:53 pgsql -> /usr/pgsql-9.1/lib/
[root at 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 **




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120723/1414a084/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 194 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120723/1414a084/attachment.pgp>