[postgis-users] How to update your SVN copy of PostGIS
Aren Cambre
aren at arencambre.com
Sat Dec 10 16:17:47 PST 2011
Ah, I see the problem now. I was thinking I'd have to reinstall all of
PostGIS 2.0 to get the *geocode_intersection* function, but looking at
http://trac.osgeo.org/postgis/changeset/8276, I realize that it's the *
tiger_geocoder* extras package as you mention below.
So I looked at the *upgrade_geocode.sql* script (
http://trac.osgeo.org/postgis/browser/trunk/extras/tiger_geocoder/tiger_2010/upgrade_geocode.sql?rev=8276),
and I guess this may help make sure I have the latest geocoding functions
in my DB.
I'll try this and see what happens.
Aren
On Sat, Dec 10, 2011 at 5:58 PM, Stephen Woodbridge <woodbri at swoodbridge.com
> wrote:
> Ok, just checking.
> http://svn.osgeo.org/postgis/**trunk/extras/tiger_geocoder/**tiger_2010/<http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/>
>
> Looks like something like this might do it:
>
> cd /usr/share/postgresql/contrib
> # edit create_geocode.sh
> # then run it
> ./create_geocode.sh
>
> or just load them from here:
>
> http://svn.osgeo.org/postgis/**trunk/extras/tiger_geocoder/**
> tiger_2010/geocode/<http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/geocode/>
>
> browse about and install what you need.
>
> -Steve W
>
>
> On 12/10/2011 6:25 PM, Aren Cambre wrote:
>
>> I refreshed the functions list and the parent DB and even opened/closed
>> pgAdmin III. :-)
>>
>> I also ran this script:
>> *SELECT * FROM pg_proc proc JOIN pg_language lang*
>> *ON proc.prolang = lang.oid*
>> *ORDER BY proname;*
>>
>> Double-checked myself with:
>> *SELECT * FROM pg_proc proc JOIN pg_language lang*
>> *ON proc.prolang = lang.oid*
>> *WHERE proname LIKE '%geocode%'*
>> *ORDER BY proname;*
>>
>> Definitely no *geocode.** functions there.
>>
>>
>> Aren
>>
>> On Sat, Dec 10, 2011 at 5:18 PM, Stephen Woodbridge
>> <woodbri at swoodbridge.com <mailto:woodbri at swoodbridge.**com<woodbri at swoodbridge.com>>>
>> wrote:
>>
>> Try right click on database and/or function list and refresh it.
>>
>>
>> On 12/10/2011 6:15 PM, Aren Cambre wrote:
>>
>> 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 <mailto:woodbri at swoodbridge.**com<woodbri at swoodbridge.com>
>> >
>> <mailto:woodbri at swoodbridge. com
>>
>> <mailto:woodbri at swoodbridge.**com <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>
>> <mailto:bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>>
>> <mailto:bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
>> <mailto: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>
>> <mailto:aren at arencambre.com <mailto:aren at arencambre.com>>
>> <mailto:aren at arencambre.com <mailto:aren at arencambre.com>
>> <mailto: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>
>> <mailto:bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>>
>> <mailto:bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
>> <mailto: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>
>> <mailto:aren at arencambre.com <mailto:aren at arencambre.com>>
>> <mailto:aren at arencambre.com <mailto:aren at arencambre.com>
>> <mailto: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>
>> <mailto:bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>>
>> <mailto:bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
>> <mailto: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
>> <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>
>> <mailto:aren at arencambre.com <mailto:aren at arencambre.com>>
>> <mailto:aren at arencambre.com <mailto:aren at arencambre.com>
>> <mailto: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
>> <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
>> <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
>> <http://refractions.net>
>>
>> <mailto:postgis-users at postgis. refractions.net
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >>
>> <mailto:postgis-users at postgis <mailto:postgis-users at postgis>**.
>> refractions.net <http://refractions.net>
>>
>> <mailto: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
>> <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> <tel:530-752-8380
>> <tel:530-752-8380>> <tel:530-752-8380 <tel:530-752-8380>
>>
>> <tel:530-752-8380 <tel:530-752-8380>>>
>>
>> >> >> bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
>> <mailto:bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>>
>> <mailto:bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
>>
>> <mailto:bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>>>
>>
>> >> >> ______________________________ _________________
>> >> >> postgis-users mailing list
>> >> >> postgis-users at postgis. refractions.net
>> <http://refractions.net>
>>
>> <mailto:postgis-users at postgis. refractions.net
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >>
>> <mailto:postgis-users at postgis <mailto:postgis-users at postgis>**.
>> refractions.net <http://refractions.net>
>>
>> <mailto: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
>> <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
>> <http://refractions.net>
>>
>> <mailto:postgis-users at postgis. refractions.net
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >>
>> <mailto:postgis-users at postgis <mailto:postgis-users at postgis>**.
>> refractions.net <http://refractions.net>
>>
>> <mailto: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
>> <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> <tel:530-752-8380
>> <tel:530-752-8380>> <tel:530-752-8380 <tel:530-752-8380>
>>
>> <tel:530-752-8380 <tel:530-752-8380>>>
>>
>> >> bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
>> <mailto:bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>>
>> <mailto:bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
>>
>> <mailto:bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>>>
>>
>> >> ______________________________ _________________
>> >> postgis-users mailing list
>> >> postgis-users at postgis. refractions.net <http://refractions.net
>> >
>>
>> <mailto:postgis-users at postgis. refractions.net
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >>
>> <mailto:postgis-users at postgis <mailto:postgis-users at postgis>**.
>> refractions.net <http://refractions.net>
>>
>> <mailto: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
>> <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 <http://refractions.net>
>>
>> <mailto:postgis-users at postgis. refractions.net
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >>
>> <mailto:postgis-users at postgis <mailto:postgis-users at postgis>**.
>> refractions.net <http://refractions.net>
>>
>> <mailto: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
>> <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> <tel:530-752-8380
>> <tel:530-752-8380>> <tel:530-752-8380 <tel:530-752-8380>
>>
>> <tel:530-752-8380 <tel:530-752-8380>>>
>>
>> bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
>> <mailto:bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>>
>> <mailto:bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
>>
>> <mailto:bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>>>
>>
>> ______________________________ _________________
>> postgis-users mailing list
>> postgis-users at postgis. refractions.net
>> <http://refractions.net>
>>
>> <mailto:postgis-users at postgis. refractions.net
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >>
>> <mailto:postgis-users at postgis <mailto:postgis-users at postgis>**.
>> refractions.net <http://refractions.net>
>>
>> <mailto: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
>> <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
>> <http://refractions.net>
>>
>> <mailto: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
>> <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 <http://refractions.net
>> >
>>
>> <mailto: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
>> <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
>> <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<http://postgis.refractions.net/mailman/listinfo/postgis-users>
>> >
>>
>>
>> ______________________________ _________________
>> postgis-users mailing list
>> 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<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/7fd922ac/attachment.html>
More information about the postgis-users
mailing list