Re: [postgis-users] postgis upgrade 1.4 to 1.5 sql file couldn't find $libdir/postgis-1.4
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
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
Re: [postgis-users] postgis upgrade 1.4 to 1.5 sql file couldn't find $libdir/postgis-1.4
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. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs ___ 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
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. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] postgis upgrade 1.4 to 1.5 sql file couldn't find $libdir/postgis-1.4
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 ? -- Bruno Friedmann ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
