<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I suppose I should be more clear with my question.<div><br><div><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>I'm trying to upgrade a postgres-8.4 installation using pg_dumpall from a new 9.1.4 install with a subsequent load.</div><div><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Helvetica; ">[root@pgsql-9.1.4 ~]# time pg_dumpall -Upostgres -c -h <a href="http://pgsql-8.4.domainname.com/">pgsql-8.4.domainname.com</a> | psql -Upostgres</div></div><div><br></div><div>It seems to be working fine with the exception of a few Postgis errors thrown at the end of the postgres load.</div><div><br></div><div><div>ERROR: could not find function "lwhistogram2d_in" in file "/usr/lib64/pgsql/liblwgeom.so"</div><div>ERROR: function public.st_histogram2d_in(cstring) does not exist</div><div>ERROR: could not find function "lwhistogram2d_out" in file "/usr/lib64/pgsql/liblwgeom.so"</div><div>ERROR: function public.st_histogram2d_out(histogram2d) does not exist</div><div>ERROR: function st_histogram2d_in(cstring) does not exist</div><div>ERROR: could not find function "build_lwhistogram2d" in file "/usr/lib64/pgsql/liblwgeom.so"</div><div>ERROR: function public.build_histogram2d(histogram2d, text, text) does not exist</div><div>ERROR: PL/pgSQL functions cannot return type histogram2d</div></div></div></blockquote><div><br></div><div><br></div><div>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.</div><div><br></div><div>-Jason</div></div></div></body></html>