[postgis-users] How to update your SVN copy of PostGIS
Stephen Woodbridge
woodbri at swoodbridge.com
Sat Dec 10 15:58:48 PST 2011
Ok, just checking.
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/
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>> 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>
> <mailto:woodbri at swoodbridge. com
> <mailto: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>>
> >> >>
> >> >> 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>>.
>
> >> >> >
> >> >> > 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>>,
>
> >> >> > 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>>
> <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>>>
>
> >> >> > 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>>
> <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>>>
>
> >> >> 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>>
> <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>>>
>
> >> > 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>>
> <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>>>
>
> >> 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>>
> <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>>>
>
> > 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>>
> <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>>>
>
> 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>>
> 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>>
> 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>
> 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>
> 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://postgis.refractions.net/mailman/listinfo/postgis-users
More information about the postgis-users
mailing list