[postgis-users] How to update your SVN copy of PostGIS
Aren Cambre
aren at arencambre.com
Sat Dec 10 15:15:36 PST 2011
Thanks.
Now here's what I don't get: where are the *geocode* and *
geocode_intersection* functions? If I look at the functions list in *
spatial_db_template*'s *public* schema (using pgAdmin III), should I see
those two? I thought they were included in the base PostGIS 2.0 product?
Aren
On Sat, Dec 10, 2011 at 5:09 PM, Stephen Woodbridge <woodbri at swoodbridge.com
> wrote:
> You can ignore all the notices. As long as you do not get a rollback, then
> things should be ok.
>
> The script is just trying to clean out potential obsolete functions that
> might be there if the database was created many versions ago and upgraded
> to this point.
>
> -Steve W
>
>
> On 12/10/2011 5:46 PM, Aren Cambre wrote:
>
>> 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
>> <mailto: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
>> <mailto: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
>> <mailto: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
>> <mailto: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 <mailto:bkpark at ucdavis.edu>> wrote:
>> >> >>
>> >> >> If you used something like...
>> >> >>
>> >> >> svn check out https://svn.osgeo.org/postgis/**trunk<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 <mailto: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<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<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<postgis-users at postgis.refractions.net>
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >
>>
>> >> >> > http://postgis.refractions.**net/mailman/listinfo/postgis-**
>> users <http://postgis.refractions.net/mailman/listinfo/postgis-users>
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bborie Park
>> >> >> Programmer
>> >> >> Center for Vectorborne Diseases
>> >> >> UC Davis
>> >> >> 530-752-8380 <tel:530-752-8380>
>> >> >> bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
>>
>> >> >> ______________________________**_________________
>> >> >> postgis-users mailing list
>> >> >> postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >
>>
>> >> >> http://postgis.refractions.**net/mailman/listinfo/postgis-**
>> users <http://postgis.refractions.net/mailman/listinfo/postgis-users>
>> >> >
>> >> >
>> >> >
>> >> > ______________________________**_________________
>> >> > postgis-users mailing list
>> >> > postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >
>>
>> >> > http://postgis.refractions.**net/mailman/listinfo/postgis-**
>> users <http://postgis.refractions.net/mailman/listinfo/postgis-users>
>> >> >
>> >>
>> >>
>> >>
>> >> --
>> >> Bborie Park
>> >> Programmer
>> >> Center for Vectorborne Diseases
>> >> UC Davis
>> >> 530-752-8380 <tel:530-752-8380>
>> >> bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
>>
>> >> ______________________________**_________________
>> >> postgis-users mailing list
>> >> postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >
>>
>> >> http://postgis.refractions.**net/mailman/listinfo/postgis-**users<http://postgis.refractions.net/mailman/listinfo/postgis-users>
>> >
>> >
>> >
>> > ______________________________**_________________
>> > postgis-users mailing list
>> > postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >
>>
>> > http://postgis.refractions.**net/mailman/listinfo/postgis-**users<http://postgis.refractions.net/mailman/listinfo/postgis-users>
>> >
>>
>>
>>
>> --
>> Bborie Park
>> Programmer
>> Center for Vectorborne Diseases
>> UC Davis
>> 530-752-8380 <tel:530-752-8380>
>> bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
>>
>> ______________________________**_________________
>> postgis-users mailing list
>> postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >
>>
>> http://postgis.refractions.**net/mailman/listinfo/postgis-**users<http://postgis.refractions.net/mailman/listinfo/postgis-users>
>>
>>
>>
>>
>> ______________________________**_________________
>> postgis-users mailing list
>> postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> http://postgis.refractions.**net/mailman/listinfo/postgis-**users<http://postgis.refractions.net/mailman/listinfo/postgis-users>
>>
>
> ______________________________**_________________
> postgis-users mailing list
> postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
> http://postgis.refractions.**net/mailman/listinfo/postgis-**users<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/ee44d0bb/attachment.html>
More information about the postgis-users
mailing list