[postgis-devel] trunk == 2.0.1

[Paul Ramsey]

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-devel
>> >>>>>>>>
>> >>>>>>> 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