[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Upgrading to PostgreSQL 8.4.1 and PostGIS 1.4.0
From: "Paragon Corporation" <lr () pcorp ! us>
Date: 2009-10-22 7:43:35
Message-ID: 6FDCE5AA5A524DF68B463E3E1D6C09B2 () b
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Paul,
As long as you have an ST_Dump function you should be fine. The dump
function is deprecated and will be removed in PostGIS 2.0. As you stated,
you can remove those additonal functions you see. The upgrade script
currently doesn't drop functions, it just adds new ones.
The other notices as you noted are expected from an upgrade. You don't need
to do a hard upgrade.
Hope that helps,
Regina
_____
From: postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] On Behalf Of Moen,
Paul T.
Sent: Wednesday, October 21, 2009 5:37 PM
To: PostGIS Users Discussion
Subject: [postgis-users] Upgrading to PostgreSQL 8.4.1 and PostGIS 1.4.0
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
I first installed PostGIS 1.4.0 and upgraded each database with the command
psql -U postgres -d DBNAME -f postgis_upgrade.sql
I encountered the following notices.
psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:215: NOTICE: type
"box3d_extent" is not yet defined
DETAIL: Creating a shell type definition.
CREATE FUNCTION
psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:219: NOTICE:
argument type box3d_extent is only a shell
and
CREATE AGGREGATE
psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:2683: NOTICE: type
"pgis_abs" is not yet defined
DETAIL: Creating a shell type definition.
CREATE FUNCTION
psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:2687: NOTICE:
argument type pgis_abs is only a shell
and
CREATE AGGREGATE
psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:2732: NOTICE:
aggregate accum_old(geometry) does not exist, skipping
DROP AGGREGATE
CREATE AGGREGATE
psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:2738: NOTICE:
aggregate st_accum_old(geometry) does not exist, skipping
I assumed these were fine and moved on to the full dump using pg_dumpall -U
postgres -o > full83dump.sql
I then installed PostgreSQL-8.4.1 and PostGIS-1.4.0 and load the data with
psql -U postgres -f full83dump.sql.
I get the following errors as each of the databases are loaded.
psql:full83dump.sql:366: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:369: ERROR: function public.st_histogram2d_in(cstring)
does not exist
psql:full83dump.sql:377: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:380: ERROR: function
public.st_histogram2d_out(histogram2d) does not exist
psql:full83dump.sql:392: ERROR: function st_histogram2d_in(cstring) does
not exist
psql:full83dump.sql:502: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:505: ERROR: function public._st_asgml(integer,
geometry, integer) does not exist
psql:full83dump.sql:1509: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:1512: ERROR: function
public.build_histogram2d(histogram2d, text, text) does not exist
psql:full83dump.sql:1525: ERROR: PL/pgSQL functions cannot return type
histogram2d
psql:full83dump.sql:1528: ERROR: function
public.build_histogram2d(histogram2d, text, text, text) does not exist
psql:full83dump.sql:1757: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:1760: ERROR: function public.create_histogram2d(box2d,
integer) does not exist
psql:full83dump.sql:2077: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:2080: ERROR: function public.dump(geometry) does not
exist
psql:full83dump.sql:2191: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:2194: ERROR: function
public.estimate_histogram2d(histogram2d, box2d) does not exist
psql:full83dump.sql:2257: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:2260: ERROR: function
public.explode_histogram2d(histogram2d, text) does not exist
psql:full83dump.sql:3105: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:3108: ERROR: function public.histogram2d_in(cstring)
does not exist
psql:full83dump.sql:3116: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:3119: ERROR: function
public.histogram2d_out(histogram2d) does not exist
psql:full83dump.sql:3215: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:3218: ERROR: function public.jtsnoop(geometry) does not
exist
psql:full83dump.sql:4976: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:4979: ERROR: function public.postgis_jts_version() does
not exist
psql:full83dump.sql:6215: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:6218: ERROR: function
public.st_build_histogram2d(histogram2d, text, text) does not exist
psql:full83dump.sql:6231: ERROR: PL/pgSQL functions cannot return type
histogram2d
psql:full83dump.sql:6234: ERROR: function
public.st_build_histogram2d(histogram2d, text, text, text) does not exist
psql:full83dump.sql:6440: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:6443: ERROR: function
public.st_create_histogram2d(box2d, integer) does not exist
psql:full83dump.sql:6638: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:6641: ERROR: function
public.st_estimate_histogram2d(histogram2d, box2d) does not exist
psql:full83dump.sql:6704: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:6707: ERROR: function
public.st_explode_histogram2d(histogram2d, text) does not exist
psql:full83dump.sql:9070: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:9073: ERROR: function public.st_text(boolean) does not
exist
psql:full83dump.sql:9379: ERROR: could not access file "$libdir/liblwgeom":
No such file or directory
psql:full83dump.sql:9382: ERROR: function public.text(boolean) does not
exist
I compared the upgraded databases to a new one created via the createdb,
createlang, psql -f postgis.sql and found a couple of differences.
The upgraded version is missing the dump(geometry) function.
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.
I see that in Ticket #144 most of the functions above are listed as a
non-issue.
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.
Thanks for any insight,
Paul
[Attachment #5 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18828"></HEAD>
<BODY
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space"> <DIV dir=ltr align=left><SPAN class=920074107-22102009><FONT \
color=#0000ff size=2 face=Arial>Paul,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=920074107-22102009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=920074107-22102009><FONT color=#0000ff
size=2 face=Arial>As long as you have an ST_Dump function you should be
fine. The dump function is deprecated and will be removed in PostGIS
2.0. As you stated, you can remove those additonal functions you
see. The upgrade script currently doesn't drop functions, it just adds new
ones.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=920074107-22102009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=920074107-22102009><FONT color=#0000ff
size=2 face=Arial>The other notices as you noted are expected from an
upgrade. You don't need to do a hard upgrade.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=920074107-22102009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=920074107-22102009><FONT color=#0000ff
size=2 face=Arial>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=920074107-22102009><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Moen,
Paul T.<BR><B>Sent:</B> Wednesday, October 21, 2009 5:37 PM<BR><B>To:</B>
PostGIS Users Discussion<BR><B>Subject:</B> [postgis-users] Upgrading to
PostgreSQL 8.4.1 and PostGIS 1.4.0<BR></FONT><BR></DIV>
<DIV></DIV>
<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
style="BORDER-BOTTOM-STYLE: none; PADDING-BOTTOM: 0px; BORDER-RIGHT-STYLE: none; \
MARGIN: 0px 0px 0px 40px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; BORDER-TOP-STYLE: \
none; BORDER-LEFT-STYLE: none; PADDING-TOP: 0px" \
class=webkit-indent-blockquote>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
style="BORDER-BOTTOM-STYLE: none; PADDING-BOTTOM: 0px; BORDER-RIGHT-STYLE: none; \
MARGIN: 0px 0px 0px 40px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; BORDER-TOP-STYLE: \
none; BORDER-LEFT-STYLE: none; PADDING-TOP: 0px" \
class=webkit-indent-blockquote>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
style="BORDER-BOTTOM-STYLE: none; PADDING-BOTTOM: 0px; BORDER-RIGHT-STYLE: none; \
MARGIN: 0px 0px 0px 40px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; BORDER-TOP-STYLE: \
none; BORDER-LEFT-STYLE: none; PADDING-TOP: 0px" \
class=webkit-indent-blockquote>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
style="BORDER-BOTTOM-STYLE: none; PADDING-BOTTOM: 0px; BORDER-RIGHT-STYLE: none; \
MARGIN: 0px 0px 0px 40px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; BORDER-TOP-STYLE: \
none; BORDER-LEFT-STYLE: none; PADDING-TOP: 0px" \
class=webkit-indent-blockquote><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
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; \
FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; \
COLOR: rgb(0,0,0); 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" \
class=Apple-style-span>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>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic