[postgis-users] How to update your SVN copy of PostGIS

Sat Dec 10 14:46:26 PST 2011

Thanks. Yup, I see it now. My mind was stuck in 3rd generation languages
where things stop when you get an exception.

The script's first gripe was that the *spatial_ref_sys* table already
exists. Shouldn't it automatically kill and reload that table? Is that a
bug?

Anyway, I deleted it and reran the script. Now I get a bunch of notices
about functions that don't exist. See attachment.

It appears it's mostly not finding overloads of functions. E.g., it says *
populate_geometry_columns()* and *populate_geometry_columns(oid)* are
missing. I do have variants with different function signatures: *
populate_geometry_columns(oid,boolean)* and *
populate_geometry_columns(boolean)*.

BTW, I'm trying to run this on my template PostGIS DB, which I named *
spatial_db_template*.

Aren

On Sat, Dec 10, 2011 at 10:26 AM, Bborie Park <bkpark at ucdavis.edu> wrote:

> Oops!  My head is always in the raster world, so I just ran with the
> raster upgrade.  Sorry about that.
>
> If you're getting an error, you'll want to scroll up past the
> transaction error message as the very first error message should be
> related to the actual statement that is failing.
>
> -bborie
>
> On Sat, Dec 10, 2011 at 6:47 AM, Aren Cambre <aren at arencambre.com> wrote:
> > Thanks. Yesterday I
> >
> found postgis_upgrade_20_minor.sql in /usr/share/postgresql/9.1/contrib/postgis-2.0.
> >
> > When I ran that, I got tons of errors like this:
> >
> psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:3235:
> > ERROR:  current transaction is aborted, commands ignored until end of
> > transaction block
> >
> > I see you mentioned rtpostgis_upgrade_20_minor.sql. Isn't that just for
> > raster functions? I searched my machine and cannot find it, anyway.
> >
> > Aren
> >
> > On Fri, Dec 9, 2011 at 10:02 PM, Bborie Park <bkpark at ucdavis.edu> wrote:
> >>
> >> Aren,
> >>
> >> Since you're tracking trunk, after you've done the configure, make and
> >> make install, you'll want to run the upgrade script
> >>
> >> rtpostgis_upgrade_20_minor.sql
> >>
> >> Usually, the file is installed in the same place as rtpostgis.sql.  If
> >> you can't find the upgrade file, you can find it in your checkout's
> >> directory at:
> >>
> >> raster/rt_pg
> >>
> >> -bborie
> >>
> >> On Fri, Dec 9, 2011 at 7:53 PM, Aren Cambre <aren at arencambre.com>
> wrote:
> >> > Thanks. I got the latest SVN snapshot. I was able to configure, make,
> >> > and
> >> > make install. The problem is there seems to be missing steps between
> >> > building the whole thing and getting changes into my preexisting
> >> > PostGIS-enabled database.
> >> >
> >> > Aren
> >> >
> >> >
> >> > On Fri, Dec 9, 2011 at 9:47 PM, Bborie Park <bkpark at ucdavis.edu>
> wrote:
> >> >>
> >> >> If you used something like...
> >> >>
> >> >> svn check out https://svn.osgeo.org/postgis/trunk
> >> >>
> >> >> You can safely run...
> >> >>
> >> >> svn update
> >> >>
> >> >> If that works, I'd recommend doing...
> >> >>
> >> >> svn cleanup
> >> >>
> >> >> -bborie
> >> >>
> >> >> On Fri, Dec 9, 2011 at 7:19 PM, Aren Cambre <aren at arencambre.com>
> >> >> wrote:
> >> >> > I admit this is a dumb question, but here it is.
> >> >> >
> >> >> > I installed PostGIS on my Ubuntu 11.10 environment a few weeks ago
> >> >> > using
> >> >> > the
> >> >> > excellent instructions
> >> >> > at
> http://www.letseehere.com/postgis-geocoder-using-tiger-2010-data.
> >> >> >
> >> >> > Since then, the geocode_intersection function was added, and I need
> >> >> > it.
> >> >> > I'm
> >> >> > not clear what is the process of replacing the older snapshot of
> >> >> > PostGIS
> >> >> > with this newer one.
> >> >> >
> >> >> > I don't see an obvious install/uninstall routine. I tried the soft
> >> >> > upgrade
> >> >> >
> >> >> >
> >> >> > at
> http://postgis.refractions.net/documentation/manual-svn/postgis_installation.html#upgrading
> ,
> >> >> > but that didn't work. Do I need to do the hard upgrade each time I
> do
> >> >> > a
> >> >> > SVN
> >> >> > update?
> >> >> >
> >> >> > Aren
> >> >> >
> >> >> > _______________________________________________
> >> >> > postgis-users mailing list
> >> >> > postgis-users at postgis.refractions.net
> >> >> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >> >> >
> >> >>
> >> >>
> >> >>
> >> >> --
> >> >> Bborie Park
> >> >> Programmer
> >> >> Center for Vectorborne Diseases
> >> >> UC Davis
> >> >> 530-752-8380
> >> >> bkpark at ucdavis.edu
> >> >> _______________________________________________
> >> >> postgis-users mailing list
> >> >> postgis-users at postgis.refractions.net
> >> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >> >
> >> >
> >> >
> >> > _______________________________________________
> >> > postgis-users mailing list
> >> > postgis-users at postgis.refractions.net
> >> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >> >
> >>
> >>
> >>
> >> --
> >> Bborie Park
> >> Programmer
> >> Center for Vectorborne Diseases
> >> UC Davis
> >> 530-752-8380
> >> bkpark at ucdavis.edu
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
>
>
>
> --
> Bborie Park
> Programmer
> Center for Vectorborne Diseases
> UC Davis
> 530-752-8380
> bkpark at ucdavis.edu
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111210/2f77542e/attachment.html>
-------------- next part --------------
postgres at aren-VirtualBox:/usr/share/postgresql/9.1/contrib/postgis-2.0$ /usr/bin/psql -d spatial_db_template -f /usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql > /var/lib/postgresql/out.txt
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:763: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "spatial_ref_sys_pkey" for table "spatial_ref_sys"
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4041: NOTICE:  aggregate memgeomunion(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4042: NOTICE:  aggregate geomunion(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4043: NOTICE:  aggregate st_geomunion(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4044: NOTICE:  aggregate accum_old(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4045: NOTICE:  aggregate st_accum_old(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4046: NOTICE:  function addgeometrycolumn(pg_catalog.varchar,pg_catalog.varchar,pg_catalog.varchar,pg_catalog.varchar,pg_catalog.int4,pg_catalog.varchar,pg_catalog.int4) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4047: NOTICE:  function addgeometrycolumn(pg_catalog.varchar,pg_catalog.varchar,pg_catalog.varchar,pg_catalog.int4,pg_catalog.varchar,pg_catalog.int4) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4048: NOTICE:  function addgeometrycolumn(pg_catalog.varchar,pg_catalog.varchar,pg_catalog.int4,pg_catalog.varchar,pg_catalog.int4) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4049: NOTICE:  function populate_geometry_columns() does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4050: NOTICE:  function populate_geometry_columns(oid) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4051: NOTICE:  function box2d_overleft(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4052: NOTICE:  function box2d_overright(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4053: NOTICE:  function box2d_left(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4054: NOTICE:  function box2d_right(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4055: NOTICE:  function box2d_contain(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4056: NOTICE:  function box2d_contained(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4057: NOTICE:  function box2d_overlap(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4058: NOTICE:  function box2d_same(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4059: NOTICE:  function box2d_intersects(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4060: NOTICE:  function st_area(geography) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4061: NOTICE:  function st_asx3d(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4062: NOTICE:  function st_box2d_overleft(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4063: NOTICE:  function st_box2d_overright(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4064: NOTICE:  function st_box2d_left(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4065: NOTICE:  function st_box2d_right(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4066: NOTICE:  function st_box2d_contain(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4067: NOTICE:  function st_box2d_contained(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4068: NOTICE:  function st_box2d_overlap(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4069: NOTICE:  function st_box2d_same(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4070: NOTICE:  function st_box2d_intersects(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4071: NOTICE:  function st_box2d_in(cstring) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4072: NOTICE:  function st_box2d_out(box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4073: NOTICE:  function st_box2d(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4074: NOTICE:  function st_box2d(box3d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4075: NOTICE:  function st_box3d(box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4076: NOTICE:  function st_box(box3d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4077: NOTICE:  function st_box3d(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4078: NOTICE:  function st_box(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4079: NOTICE:  function st_concavehull(geometry,pg_catalog.float8) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4080: NOTICE:  function st_text(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4081: NOTICE:  function st_geometry(box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4082: NOTICE:  function st_geometry(box3d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4083: NOTICE:  function st_geometry(text) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4084: NOTICE:  function st_geometry(bytea) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4085: NOTICE:  function st_bytea(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4086: NOTICE:  function st_addbbox(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4087: NOTICE:  function st_dropbbox(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4088: NOTICE:  function st_hasbbox(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4089: NOTICE:  function cache_bbox() does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4090: NOTICE:  function st_cache_bbox() does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4091: NOTICE:  function st_length(geography) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4092: NOTICE:  function st_perimeter(geography) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4093: NOTICE:  function transform_geometry(geometry,text,text,pg_catalog.int4) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4094: NOTICE:  function collector(geometry,geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4095: NOTICE:  function st_collector(geometry,geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4096: NOTICE:  function geom_accum(geometry[],geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4097: NOTICE:  function st_geom_accum(geometry[],geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4098: NOTICE:  function collect_garray(geometry[]) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4099: NOTICE:  function st_collect_garray(geometry[]) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4100: NOTICE:  function geosnoop(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4101: NOTICE:  function jtsnoop(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4102: NOTICE:  function st_noop(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4103: NOTICE:  function st_max_distance(geometry,geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4104: NOTICE:  function st_minimumboundingcircle(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4105: NOTICE:  function st_geometry_analyze(internal) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4106: NOTICE:  function st_geometry_in(cstring) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4107: NOTICE:  function st_geometry_out(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4108: NOTICE:  function st_geometry_recv(internal) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4109: NOTICE:  function st_geometry_send(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4110: NOTICE:  function st_spheroid_in(cstring) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4111: NOTICE:  function st_spheroid_out(spheroid) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4112: NOTICE:  function st_geometry_lt(geometry,geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4113: NOTICE:  function st_geometry_gt(geometry,geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4114: NOTICE:  function st_geometry_ge(geometry,geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4115: NOTICE:  function st_geometry_eq(geometry,geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4116: NOTICE:  function st_geometry_cmp(geometry,geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4117: NOTICE:  function snaptogrid(geometry,float8,float8) does not exist, skipping