I suppose I should be more clear with my question. > 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
These errors are keeping me up at night. Are they safe to ignore? I'm speculating that lwhistogram2d functions were deprecated in postgres-9.1.4. Or am I way off base here? Thanks for any help. -Jason
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