[postgis-devel] trunk == 2.0.1

Paragon Corporation lr at pcorp.us
Thu Apr 5 16:47:21 PDT 2012 

Ah -- sorry Paul- I thought the topic switched. 

> -----Original Message-----
> From: postgis-devel-bounces at postgis.refractions.net 
> [mailto:postgis-devel-bounces at postgis.refractions.net] On 
> Behalf Of Paul Ramsey
> Sent: Thursday, April 05, 2012 7:45 PM
> To: PostGIS Development Discussion
> Subject: Re: [postgis-devel] trunk == 2.0.1
> 
> You're confusing a dump/restore upgrade with what this poor 
> soul did, which was remove all his old DLLs and write the new 
> ones into place.
> Even if he updated all his function signatures to point at 
> the new DLL, he'd still be SOL, since the objects on the disk 
> aren't readable by the new DLLs.
> 
> P
> 
> On Thu, Apr 5, 2012 at 4:38 PM, Paragon Corporation 
> <lr at pcorp.us> wrote:
> > I took out my sloppy install approach from the docs since the 
> > pg_restore was cleaner, but for those who have already 
> screwed up and 
> > don't have the patience to rerestore their backup.
> >
> > You should be able to recover by:
> >
> > running the
> >
> > postgis_upgrade_minor.sql and raster_update_minor.sql files 
> afterward.
> >
> >
> > People who used extensions -- you won't be able to run 
> those scripts, 
> > but you can run the drop function statements at the end.
> >
> > That in theory is all you need to run to fix a faulty upgrade.
> >
> > Hope that helps,
> > Regina
> > http://www.postgis.us
> >
> >
> >
> >> -----Original Message-----
> >> From: postgis-devel-bounces at postgis.refractions.net
> >> [mailto:postgis-devel-bounces at postgis.refractions.net] On 
> Behalf Of 
> >> Paul Ramsey
> >> Sent: Thursday, April 05, 2012 7:17 PM
> >> To: PostGIS Development Discussion
> >> Subject: Re: [postgis-devel] trunk == 2.0.1
> >>
> >> Right, you can mostly get away with just slamming an 
> unfiltered dump 
> >> file onto the new database, subject to (a) being willing to ignore 
> >> the many errors you will log and (b) the specific issues you note 
> >> below.
> >>
> >> P.
> >>
> >> On Thu, Apr 5, 2012 at 3:36 PM, Brian Hamlin <maplabs at light42.com> 
> >> wrote:
> >> > Hi All-
> >> >
> >> >  this was a startling thing to read!
> >> > A quick read of postgis_restore.pl says to me though..
> >> >
> >> > IF you have old topology constructs or IF you have old WKT
> >> Raster or
> >> > IF you have custom, non-standard SRIDs in use or IF
> >> (unlikely) you are
> >> > trying to restore PostGIS function calls somehow from the .dump 
> >> > file
> >> >
> >> > THEN you must use postgis_restore.pl OTHERWISE no, it is not 
> >> > required
> >> >
> >> >  This is the start of a rather important FAQ I think !
> >> >
> >> > best regards
> >> >
> >> > ==
> >> > Brian Hamlin
> >> > GeoCal
> >> > OSGeo California Chapter
> >> > 415-717-4462 cell
> >> >
> >> >
> >> >
> >> > On Apr 5, 2012, at 1:55 PM, Paul Ramsey wrote:
> >> >
> >> >> Angelos, see this
> >> >>
> >> >>
> >> >>
> >> 
> http://gis.stackexchange.com/questions/22945/postgis-2-0-upgrade-prob
> >> >> lem-with-postgres-data
> >> >>
> >> >> Is there any way to warn people as they upgrade, because
> >> 2.0 is not
> >> >> backwards compatible with 1.5. They need to dump their database 
> >> >> before they upgrade and run it through postgis_restore.pl while 
> >> >> loading it back into 2.0.
> >> >>
> >> >> P.
> >> >>
> >> >> On Tue, Apr 3, 2012 at 1:17 PM, Angelos Tzotsos 
> >> >> <gcpp.kalxas at gmail.com>
> >> >> wrote:
> >> >>>
> >> >>> OK, no one can hear us :)
> >> >>>
> >> >>>
> >> >>> On 04/03/2012 11:15 PM, Paul Ramsey wrote:
> >> >>>>
> >> >>>>
> >> >>>> Yes. Sssssh :)
> >> >>>> thanks,
> >> >>>> P
> >> >>>>
> >> >>>> On Tue, Apr 3, 2012 at 1:15 PM, Angelos 
> >> >>>> Tzotsos<gcpp.kalxas at gmail.com>
> >> >>>>  wrote:
> >> >>>>>
> >> >>>>>
> >> >>>>> Hi Paul,
> >> >>>>>
> >> >>>>> I assumed this is the final:
> >> >>>>> http://postgis.org/download/postgis-2.0.0.tar.gz
> >> >>>>>
> >> >>>>> Angelos
> >> >>>>>
> >> >>>>>
> >> >>>>> On 04/03/2012 11:11 PM, Paul Ramsey wrote:
> >> >>>>>>
> >> >>>>>>
> >> >>>>>> Are all the versions numbers correct? What did you 
> package off 
> >> >>>>>> of? I haven't released the tarball yet...
> >> >>>>>> P.
> >> >>>>>>
> >> >>>>>> On Tue, Apr 3, 2012 at 1:09 PM, Angelos 
> >> >>>>>> Tzotsos<gcpp.kalxas at gmail.com>
> >> >>>>>>  wrote:
> >> >>>>>>>
> >> >>>>>>>
> >> >>>>>>> On 04/03/2012 10:39 PM, Paul Ramsey wrote:
> >> >>>>>>>>
> >> >>>>>>>>
> >> >>>>>>>> Devs,
> >> >>>>>>>> I have tagged 2.0.0. I have not branched a 2.0 
> yet. I would 
> >> >>>>>>>> like to hold 2.0 development on trunk until we do a 2.0.1 
> >> >>>>>>>> release. At that point we can create a 2.0 branch
> >> and bring new
> >> >>>>>>>> features online in trunk.
> >> >>>>>>>> Uploading and preparing text now for release announcement.
> >> >>>>>>>> P.
> >> >>>>>>>> _______________________________________________
> >> >>>>>>>> postgis-devel mailing list
> >> >>>>>>>> postgis-devel at postgis.refractions.net
> >> >>>>>>>> 
> http://postgis.refractions.net/mailman/listinfo/postgis-deve
> >> >>>>>>>> l
> >> >>>>>>>>
> >> >>>>>>> Hi all,
> >> >>>>>>>
> >> >>>>>>> I have completed packaging of v2.0 for openSUSE.
> >> >>>>>>> Waiting the announcement to release the rpms :)
> >> >>>>>>>
> >> >>>>>>> Regards,
> >> >>>>>>> Angelos
> >> >>>>>>>
> >> >>>>>>> --
> >> >>>>>>> Angelos Tzotsos
> >> >>>>>>> Remote Sensing Laboratory
> >> >>>>>>> National Technical University of Athens 
> >> >>>>>>> http://users.ntua.gr/tzotsos
> >> >>>>>>>
> >> >>>>>>> _______________________________________________
> >> >>>>>>> postgis-devel mailing list
> >> >>>>>>> postgis-devel at postgis.refractions.net
> >> >>>>>>> 
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
> >> >>>>>>
> >> >>>>>>
> >> >>>>>> _______________________________________________
> >> >>>>>> postgis-devel mailing list
> >> >>>>>> postgis-devel at postgis.refractions.net
> >> >>>>>> 
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
> >> >>>>>>
> >> >>>>>
> >> >>>>> --
> >> >>>>> Angelos Tzotsos
> >> >>>>> Remote Sensing Laboratory
> >> >>>>> National Technical University of Athens 
> >> >>>>> http://users.ntua.gr/tzotsos
> >> >>>>>
> >> >>>>> _______________________________________________
> >> >>>>> postgis-devel mailing list
> >> >>>>> postgis-devel at postgis.refractions.net
> >> >>>>> http://postgis.refractions.net/mailman/listinfo/postgis-devel
> >> >>>>
> >> >>>>
> >> >>>> _______________________________________________
> >> >>>> postgis-devel mailing list
> >> >>>> postgis-devel at postgis.refractions.net
> >> >>>> http://postgis.refractions.net/mailman/listinfo/postgis-devel
> >> >>>>
> >> >>>
> >> >>>
> >> >>> --
> >> >>> Angelos Tzotsos
> >> >>> Remote Sensing Laboratory
> >> >>> National Technical University of Athens
> >> http://users.ntua.gr/tzotsos
> >> >>>
> >> >>> _______________________________________________
> >> >>> postgis-devel mailing list
> >> >>> postgis-devel at postgis.refractions.net
> >> >>> http://postgis.refractions.net/mailman/listinfo/postgis-devel
> >> >>
> >> >> _______________________________________________
> >> >> postgis-devel mailing list
> >> >> postgis-devel at postgis.refractions.net
> >> >> http://postgis.refractions.net/mailman/listinfo/postgis-devel
> >> >>
> >> >
> >> > _______________________________________________
> >> > postgis-devel mailing list
> >> > postgis-devel at postgis.refractions.net
> >> > http://postgis.refractions.net/mailman/listinfo/postgis-devel
> >> _______________________________________________
> >> postgis-devel mailing list
> >> postgis-devel at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-devel
> >>
> >
> >
> > _______________________________________________
> > postgis-devel mailing list
> > postgis-devel at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-devel
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>

More information about the postgis-devel mailing list