Bug#895388: Symbol removal prevents upgrade of postgres 9.6 cluster with postgis columns

[Adrian Bunk]

On Wed, Apr 11, 2018 at 09:43:59AM +0300, Adrian Bunk wrote:
> Control: reopen -1
> Control: severity -1 serious
> 
> On Wed, Apr 11, 2018 at 07:04:40AM +0200, Sebastiaan Couwenberg wrote:
> > severity 895388 normal
> > tags 895388 wontfix
> > thanks
> > 
> > On 04/10/2018 11:30 PM, Ari Pollak wrote:
> > > I have postgresql-9.6-postgis-2.3 installed (no longer in Debian
> > > buster, but was in stretch, current stable). After upgrading libsfcgal1
> > > and trying to use postgis on my existing Postgres 9.6 server, I get an
> > > error when trying to access a table with a geography column:
> > > 
> > > [...]
> > > 
> > > That would be fine if I could upgrade the database to Postgres 10, since
> > > the new postgresql-10-postgis-2.4 package doesn't depend on libsfcgal1,
> > > but I can't do that with the missing symbol:
> > > 
> > > [...]
> > > 
> > > If I downgrade libsfcgal1, all of that works fine.
> > 
> > Upgrading postgis databases is not supported by the Debian package. You
> > need to recreate the postgis databases, or use the symlink hacks.
> 
> This bug is not about postgis databases, it is about a broken library.
> 
> > The postgis package in unstable will be rebuilt with the new sfcgal once
> > that migrates to testing.
> 
> Does that work for you?
> 
> I would expect linking to fail due to this bug.

I think I'm wrong on the latter:
As a plugin it would link but fail with the same error when trying to 
use it.

Either way, SFCGAL no longer linked with CGAL is a pretty fatal bug.

cu
Adrian

-- 

       "Is there not promise of rain?" Ling Tan asked suddenly out
        of the darkness. There had been need of rain for many days.
       "Only a promise," Lao Er said.
                                       Pearl S. Buck - Dragon Seed