Bug#914216: postgresql-11-postgis-2.5: CREATE EXTENSION postgis does not finish

[Timo Kalliomäki]

Package: postgresql-11-postgis-2.5
Version: 2.5.0+dfsg-2
Severity: important

Dear Maintainer,

on the Buster postgresql-11-postgis-2.5(-scripts), the command CREATE
EXTENSION postgis; produces no results and gets stuck indefinitely
(had to kill -9). The corresponding steps work on Stretch as expected.

Steps to reproduce:

apt-get install -y --no-install-recommends postgresql
postgresql-11-postgis-2.5 postgresql-11-postgis-2.5-scripts
service postgresql start
su postgres
psql -c "CREATE DATABASE sampledb;"
psql -c "CREATE EXTENSION postgis;" sampledb

I could not manage to produce any useful debug information; e.g. with
-d 5 I got similar command parse information on Stretch and Buster but
no details about the actual extension setup.

Br,
Timo

-- System Information:
Debian Release: buster/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 4.18.0-2-amd64 (SMP w/4 CPU cores)
Locale: LANG=fi_FI.UTF-8, LC_CTYPE=fi_FI.UTF-8 (charmap=UTF-8),
LANGUAGE= (charmap=UTF-8)
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages postgresql-11-postgis-2.5 depends on:
ii  libc6            2.27-8
ii  libgdal20        2.3.2+dfsg-2+b2
ii  libgeos-c1v5     3.7.0-1
ii  libjson-c3       0.12.1-1.3
ii  liblwgeom-2.5-0  2.5.0+dfsg-2
ii  libpcre3         2:8.39-11
ii  libproj13        5.2.0-1
ii  libprotobuf-c1   1.3.1-1+b1
ii  libsfcgal1       1.3.6-1
ii  libxml2          2.9.4+dfsg1-7+b2
ii  postgresql-11    11.1-1+b1

Versions of packages postgresql-11-postgis-2.5 recommends:
ii  postgresql-11-postgis-2.5-scripts  2.5.0+dfsg-2

Versions of packages postgresql-11-postgis-2.5 suggests:
pn  postgis  <none>

-- no debconf information