Bug#886742: postgresql-9.4-postgis-2.1 missing in stretch

[Bas Couwenberg]

On 2018-01-10 10:22, Jürgen Fuchsberger wrote:
> On 2018-01-10 09:10, Bas Couwenberg wrote:
>> On 2018-01-10 08:35, Jürgen Fuchsberger wrote:
>>> On 2018-01-09 18:18, Sebastiaan Couwenberg wrote:
>>>> severity 886742 normal
>>>> thanks
>>>> 
>>>> Hi Juergen,
>>>> 
>>>> On 01/09/2018 02:16 PM, Bas Couwenberg wrote:
>>>>> On 2018-01-09 14:08, Christoph Berg wrote:
>>>>>> Re: Juergen Fuchsberger 2018-01-09
>>>>>>> Due to missing postgresql-9.4-postgis-2.1 in stretch, a postgis
>>>>>>> enabled
>>>>>>> database becomes corrupt when upgrading from jessie to stretch 
>>>>>>> since
>>>>>>> the required postgis libraries are missing. This can cause 
>>>>>>> serious
>>>>>>> data
>>>>>>> loss, because once upgraded to stretch, the postgis data can't be
>>>>>>> accesed nor dumped (Database gives error "could not access file
>>>>>>> "$libdir/postgis-2.1": no such file or directory").
>>>> 
>>>> The database is not corrupt, your old database still works (after
>>>> installing the old postgis).
>>> 
>>> Sure, but I can't install the old postgis-2.1 because it is not
>>> available in stretch.
>> 
>> So temporarily add the sources for jessie and install postgis from
>> jessie and remove the sources again.
>> 
>> Or use the symlink hack.
>> 
>>> I think the problem is that postgis-2.1 was removed on updating which
>>> should not be the case, should it?
>> 
>> Removing packages no longer in the distribution your upgrading to is
>> quite common.
>> 
> OK, this is all clear - *but*: is this behavior really ok? Isn't it
> affecting every single Debian user when upgrading from Jessie to 
> Stretch
> if he is running postgresql + postgis?

Upgrades of postgis databases have never been supported on Debian, this 
affects all users and they are generally aware of this issue and 
reimport their databases into the new cluster after distribution 
upgrades.

Having postgis database upgrades work with pg_upgradecluster would be 
great, but this is not something the Debian package can provide, the 
upstream developers need to support this scenario, e.g by not including 
the version in the extension filename.

Kind Regards,

Bas