<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>I have been trying to upgrade my PostgreSQL 8.3.8 to PostGIS 1.3.6 to PostgreSQL 8.4.1 and PostGIS 1.4.0</div><div><br></div><div>I first installed PostGIS 1.4.0 and upgraded each database with the command</div><div>psql -U postgres -d DBNAME -f postgis_upgrade.sql</div><div><br></div><div>I encountered the following notices.</div><div><br></div><div><blockquote class="webkit-indent-blockquote" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 40px; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:215: NOTICE: type "box3d_extent" is not yet defined<br>DETAIL: Creating a shell type definition.<br>CREATE FUNCTION<br>psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:219: NOTICE: argument type box3d_extent is only a shell</blockquote><div><div>and</div></div><blockquote class="webkit-indent-blockquote" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 40px; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">CREATE AGGREGATE<br>psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:2683: NOTICE: type "pgis_abs" is not yet defined<br>DETAIL: Creating a shell type definition.<br>CREATE FUNCTION<br>psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:2687: NOTICE: argument type pgis_abs is only a shell</blockquote><div><div>and </div></div><blockquote class="webkit-indent-blockquote" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 40px; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">CREATE AGGREGATE<br>psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:2732: NOTICE: aggregate accum_old(geometry) does not exist, skipping<br>DROP AGGREGATE<br>CREATE AGGREGATE<br>psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:2738: NOTICE: aggregate st_accum_old(geometry) does not exist, skipping</blockquote><blockquote class="webkit-indent-blockquote" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 40px; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><br></blockquote></div><div><div><div>I assumed these were fine and moved on to the full dump using pg_dumpall -U postgres -o > full83dump.sql</div><div><br></div></div><div>I then installed PostgreSQL-8.4.1 and PostGIS-1.4.0 and load the data with psql -U postgres -f full83dump.sql.</div><div><br></div><div>I get the following errors as each of the databases are loaded.</div><div><div><div><div>psql:full83dump.sql:366: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:369: ERROR: function public.st_histogram2d_in(cstring) does not exist</div><div>psql:full83dump.sql:377: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:380: ERROR: function public.st_histogram2d_out(histogram2d) does not exist</div><div>psql:full83dump.sql:392: ERROR: function st_histogram2d_in(cstring) does not exist</div><div><div>psql:full83dump.sql:502: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:505: ERROR: function public._st_asgml(integer, geometry, integer) does not exist</div><div><div>psql:full83dump.sql:1509: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:1512: ERROR: function public.build_histogram2d(histogram2d, text, text) does not exist</div><div>psql:full83dump.sql:1525: ERROR: PL/pgSQL functions cannot return type histogram2d</div><div>psql:full83dump.sql:1528: ERROR: function public.build_histogram2d(histogram2d, text, text, text) does not exist</div><div><div>psql:full83dump.sql:1757: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:1760: ERROR: function public.create_histogram2d(box2d, integer) does not exist</div><div><div>psql:full83dump.sql:2077: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:2080: ERROR: function public.dump(geometry) does not exist</div><div><div>psql:full83dump.sql:2191: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:2194: ERROR: function public.estimate_histogram2d(histogram2d, box2d) does not exist</div><div><div>psql:full83dump.sql:2257: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:2260: ERROR: function public.explode_histogram2d(histogram2d, text) does not exist</div><div><div>psql:full83dump.sql:3105: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:3108: ERROR: function public.histogram2d_in(cstring) does not exist</div><div>psql:full83dump.sql:3116: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:3119: ERROR: function public.histogram2d_out(histogram2d) does not exist</div><div><div>psql:full83dump.sql:3215: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:3218: ERROR: function public.jtsnoop(geometry) does not exist</div><div><div>psql:full83dump.sql:4976: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:4979: ERROR: function public.postgis_jts_version() does not exist</div><div><div>psql:full83dump.sql:6215: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:6218: ERROR: function public.st_build_histogram2d(histogram2d, text, text) does not exist</div><div>psql:full83dump.sql:6231: ERROR: PL/pgSQL functions cannot return type histogram2d</div><div>psql:full83dump.sql:6234: ERROR: function public.st_build_histogram2d(histogram2d, text, text, text) does not exist</div><div><div>psql:full83dump.sql:6440: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:6443: ERROR: function public.st_create_histogram2d(box2d, integer) does not exist</div><div><div>psql:full83dump.sql:6638: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:6641: ERROR: function public.st_estimate_histogram2d(histogram2d, box2d) does not exist</div><div><div>psql:full83dump.sql:6704: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:6707: ERROR: function public.st_explode_histogram2d(histogram2d, text) does not exist</div><div><div>psql:full83dump.sql:9070: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:9073: ERROR: function public.st_text(boolean) does not exist</div><div><div>psql:full83dump.sql:9379: ERROR: could not access file "$libdir/liblwgeom": No such file or directory</div><div>psql:full83dump.sql:9382: ERROR: function public.text(boolean) does not exist</div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><div><br></div><div>I compared the upgraded databases to a new one created via the createdb, createlang, psql -f postgis.sql and found a couple of differences.</div><div>The upgraded version is missing the dump(geometry) function.<br>The upgraded version has 2 extra functions, update_geometry_stats(),update_geometry_stats(character varying,character varying) that do not exist in new database I created. I believe these were used in upgrades from Postgresql 7.4 and lower so I should just drop these.<br></div><div><br class="webkit-block-placeholder"></div><div><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; ">I see that in Ticket #144 most of the functions above are listed as a non-issue. </span></div><div><br class="webkit-block-placeholder"></div><div>Am I correct in proceeding without worrying about the above errors? Do I need to do a hard upgrade instead? If so, should I use the new_postgis_restore.pl script? I have found no information in the documentation about this new script.</div><div><br></div><div><br></div><div>Thanks for any insight,</div><div><br></div><div>Paul</div>
<br></body></html>