[postgis-users] 1.3 to 1.4 upgrade

[Matt Foster]

When you say you restore your 1.3 on top of a new 1.4 install, do you 
mean that you dump your data only from the 1.3, and insert that into the 
new 1.4?  I didn't know that would work.

I did use the Perl script.

This on on RHEL 5 x86_64.

Matt


Paragon Corporation wrote:
> Those errors look fine to me.  Those things don't exist in PostGIS 1.4 so
> they simply won't be loaded.
>
> Are you using the perl upgrade script.  Haven't tried that so not absolutely
> sure.  We usually just restore our old 1.3 ontop of a new mint PostGIS 1.4
> and that works pretty well for us, but then again we were doing both
> migrations at the same time.
>
> Which platform are you on by the way?
>
> Leo 
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Matt
> Foster
> Sent: Thursday, August 20, 2009 12:06 PM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] 1.3 to 1.4 upgrade
>
> Hello,
>
> I'm moving some Postgis databases to a new physical server.  I decided to
> use this opportunity to move from Postgis 1.3 to 1.4.  I'm also going from
> Postgres 8.2 to 8.3 (I'm not brave enough to go to the brand new PG 8.4!).
>
> I concluded that the right thing to do was to use the "Hard Upgrade" 
> method to make this move.  When I ran the upgrade Perl script to restore the
> dump on to the new server, I got the following error messages...
>
> ERROR:  language "plpgsql" already exists
> ERROR:  function st_histogram2d_in(cstring) does not exist
> ERROR:  could not access file "$libdir/liblwgeom": No such file or directory
> ERROR:  function public.asukml(geometry, integer, integer) does not exist
> ERROR:  could not access file "$libdir/liblwgeom": No such file or directory
> ERROR:  function public.asukml(geometry, integer) does not exist
> ERROR:  could not access file "$libdir/liblwgeom": No such file or directory
> ERROR:  function public.asukml(geometry) does not exist
> ERROR:  could not access file "$libdir/liblwgeom": No such file or directory
> ERROR:  function public.st_asukml(geometry, integer, integer) does not exist
> ERROR:  could not access file "$libdir/liblwgeom": No such file or directory
> ERROR:  function public.st_asukml(geometry, integer) does not exist
> ERROR:  could not access file "$libdir/liblwgeom": No such file or directory
> ERROR:  function public.st_asukml(geometry) does not exist
> ERROR:  could not access file "$libdir/liblwgeom": No such file or directory
> ERROR:  function public.st_text(boolean) does not exist
> ERROR:  could not access file "$libdir/liblwgeom": No such file or directory
> ERROR:  function public.text(boolean) does not exist
>
> Following the documentation, I grep'd for ^KEEPING in the log file I
> created, and found these entries...
>
> KEEPING TYPE [histogram2d]
> KEEPING TYPE [histogram2d]
> KEEPING FUNCTION: [askml(geometry, integer, integer)] KEEPING FUNCTION:
> [asukml(geometry, integer, integer)] KEEPING FUNCTION: [asukml(geometry,
> integer)] KEEPING FUNCTION: [asukml(geometry)] KEEPING FUNCTION:
> [st_askml(geometry, integer, integer)] KEEPING FUNCTION:
> [st_asukml(geometry, integer, integer)] KEEPING FUNCTION:
> [st_asukml(geometry, integer)] KEEPING FUNCTION: [st_asukml(geometry)]
> KEEPING FUNCTION: [st_text(bool)] KEEPING FUNCTION: [text(bool)] KEEPING
> FUNCTION: [update_geometry_stats()] KEEPING FUNCTION:
> [update_geometry_stats(character varying, character varying)] KEEPING
> AGGREGATE [geomunion(geometry)]
>
> Are these messages normal or are they indicating a problem?  Some searching
> of the mailing list archive led me to believe that they are normal, but I
> would like to be sure before I proceed with the other databases.
>
> Matt
>
> --
> Do not go where the path may lead; go instead where there is no path and
> leave a trail.
> -- Ralph Waldo Emerson
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>   

-- 
Do not go where the path may lead; go instead where there is no path and leave a trail.
-- Ralph Waldo Emerson

-------------- next part --------------
A non-text attachment was scrubbed...
Name: matthew_foster.vcf
Type: text/x-vcard
Size: 229 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090821/9198e77d/attachment.vcf>