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 <bkp...@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 <a...@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 <bkp...@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 <a...@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@postgis.refractions.net > >> > http://postgis.refractions.net/mailman/listinfo/postgis-users > >> > > >> > >> > >> > >> -- > >> Bborie Park > >> Programmer > >> Center for Vectorborne Diseases > >> UC Davis > >> 530-752-8380 > >> bkp...@ucdavis.edu > >> _______________________________________________ > >> postgis-users mailing list > >> postgis-users@postgis.refractions.net > >> http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > > -- > Bborie Park > Programmer > Center for Vectorborne Diseases > UC Davis > 530-752-8380 > bkp...@ucdavis.edu > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users