[postgis-users] postgis upgrade 1.4 to 1.5 sql file couldn't find $libdir/postgis-1.4

[Bruno Friedmann]

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-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at 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