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

[Adrian Bunk]

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.

> Kind Regards,
> 
> Bas

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