Bruno, Hmm hadn't thought about this as a standard practice. Now you point it out, I guess I can see the thought process behind this.
The main issue is that since PostGIS no longer names the .so/.dlls the same as the old name, as soon as you uninstall the old version, you have temporarily broken your databases until you upgrade them. This was not the case in the past. So really package managers should be treating these versions as being different animals. This will become more of an issue when PostGIS 2.0 comes around. The reason we changed towards this path is that it allows for two versions of PostGIS to coexist on the same server thus allowing one to slowly migrate to a newer version and also cross test behavior. In the case of PostGIS 2.0, there will be many breaking changes, so you definitely would not want to uninstall the old version when you install the new. Paul, Kevin, Mark et. Al -- any thoughts on the matter. I suspect we'll be seeing more of this issue crop up. Thanks, Regina -----Original Message----- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Bruno Friedmann Sent: Friday, February 26, 2010 2:00 AM To: postgis-users@postgis.refractions.net Subject: Re: [postgis-users] postgis upgrade 1.4 to 1.5 sql file couldn't find $libdir/postgis-1.4 Yes you get it, but in fact it's the usual process with .deb or .rpm (which I use) the old version is removed before the new one is installed. To have success in the update process, I decide I can comment the line described in the postigs upgrade sql script those calling postgis_major_version_check(). Without this function, the process seems to goes well, in fact it ended correctly, and I have all things working. I'm also talking with Otto Dasseau ( the guy who make kindly the openSUSE rpm I use ). So what would be you recommendation for packager about the upgrade process : did they should leave the old previous version installed the time of the upgrade process ? Or could we imagine to capture the error raised by the postgis_major_version_check() and by passed it if old lib version cannot be checked ? On 02/24/2010 12:41 PM, Paragon Corporation wrote: > Bruno, > > From the error its sounds like the PostGIS 1.4 has been uninstalled > in the process of upgrading to 1.5. This is a big no no as if the > old is uninstalled before the database is upgraded, you run into this > kind of issue since they now use different file names. > > > > -----Original Message----- > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of > Mark Cave-Ayland > Sent: Wednesday, February 24, 2010 5:04 AM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] postgis upgrade 1.4 to 1.5 sql file > couldn't find $libdir/postgis-1.4 > > Bruno Friedmann wrote: > >> Doesn't know if already reported or what I'm doing wrong. >> >> In rpm (suppose to be the same with .deb) if you upgrade postgis from >> 1.4 to 1.5 the postgis-1.4 referenced in function doesn't exist after > upgrade. >> >> As the default postgis upgrade script call the select >> postgis_lib_version(); we get a fatal error >> ERROR: could not access file "$libdir/postgis-1.4": No such file or >> directory >> >> and all the process fail leaving normal user in trouble ... >> >> I've try to bypass it commenting the SELECT >> postgis_major_version_check(); and get the sql executed ... >> >> Any comments ? > > Hi Bruno, > > Sorry but I'm not really sure what's happening here - I know that > people have tested the upgrade script when upgrading from 1.4 to 1.5 > before the final release and reported that it works. > > I suspect you will need to talk to the maintainer of the .deb packages > you are using to find out why this is failing. > > > HTH, > > Mark. > -- Bruno Friedmann Ioda-Net Sàrl 2830 Vellerat - Switzerland Tél : ++41 32 435 7171 Fax : ++41 32 435 7172 gsm : ++41 78 802 6760 www.ioda-net.ch Centre de Formation et de Coaching En Ligne www.cfcel.com _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
