<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi there,<div><br></div><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><br></div><div>I've installed the following postgis RPMs:</div><div><div>[root@vrsdb03 ~]# rpm -qa |grep postgis91</div><div>postgis91-1.5.4-1.rhel6.x86_64</div><div>postgis91-utils-1.5.4-1.rhel6.x86_64</div></div><div><br></div><div>As well as doing a necessary compile of the postgis source against my postgresql-9.1.4 install.</div><div><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> -------------- Compiler Info ------------- </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> C compiler: gcc -g -O2</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> C++ compiler: g++ -g -O2</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> -------------- Dependencies -------------- </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> GEOS config: /usr/bin/geos-config</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> GEOS version: 3.3.5</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> PostgreSQL config: /usr/pgsql-9.1/bin//pg_config</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> PostgreSQL version: PostgreSQL 9.1.4</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> PROJ4 version: 47</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> Libxml2 config: /usr/bin/xml2-config</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> Libxml2 version: 2.7.6</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> PostGIS debug level: 0</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> -------- Documentation Generation -------- </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> xsltproc: /usr/bin/xsltproc</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> xsl style sheets: </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> dblatex: </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "> convert: </div></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; ">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.</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; ">[root@pgsql-9.1.4 lib64]# pwd</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; ">/usr/lib64</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><span class="Apple-style-span">[root@</span>pgsql-9.1.4<span class="Apple-style-span"> lib64]# ll pgsql</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; ">lrwxrwxrwx 1 root root 19 Jul 21 13:53 pgsql -> /usr/pgsql-9.1/lib/</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><span class="Apple-style-span">[root@</span>pgsql-9.1.4<span class="Apple-style-span"> lib64]# ll pgsql/liblwgeom.so pgsql/postgis-1.5.so </span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; ">lrwxrwxrwx 1 root root 14 Jul 20 08:39 pgsql/liblwgeom.so -> postgis-1.5.so</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; ">-rwxr-xr-x 1 root root 1975408 Jul 21 19:52 pgsql/postgis-1.5.so</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; ">Thanks,</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><br></div></div><div apple-content-edited="true">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Jason Mahony<br>Systems Engineer<br>Mobile: 415-471-9131<br>VerticalResponse, Inc<br><br>** Save a tree. Don't print me **</div></div></div><br class="Apple-interchange-newline"></div><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">
</div>
<br></div></body></html>