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

[Paragon Corporation]

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-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Bruno
Friedmann
Sent: Friday, February 26, 2010 2:00 AM
To: postgis-users at 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-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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users