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

Bborie Park bkpark at ucdavis.edu
Sat Dec 10 08:26:31 PST 2011


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



More information about the postgis-users mailing list