Hi, I was just about to report to pkg-postgresql-pub...@lists.alioth.debian.org when I found that Jeremy already opened a bug. I just started on this, but still I wanted to share the bit I had.
I hit it while trying to prepare the recent postgres mircorelease for Ubuntu. At least the issue seems 100% reproducible with autopkgtests and locally as well. The error comes down to pg_buildext installcheck [...] test tablespace ... FAILED [...] ERROR: could not create unique index "idx_badindex_n" DETAIL: Key (n)=(10) is duplicated. STATEMENT: CREATE UNIQUE INDEX CONCURRENTLY idx_badindex_n ON tbl_badindex (n); Jeremy already pointed out the issue is not specific to Ubuntu, Debian hits the same in debci with the recent 9.6.2 update, see [1]. As mentioned before the case can be reproduced easily in any Debian/Ubuntu environment with pg-repack, example: # prep current debian system $ lxc launch 95fba011e3ad debiansid-postgres-fail-stableupdate $ lxc exec debiansid-postgres-fail-stableupdate bash # get packages and source $ apt-get install postgresql-9.6-repack postgresql-server-dev-all dpkg-dev $ echo "deb-src http://httpredir.debian.org/debian sid main" >> /etc/apt/sources.list $ apt-get update $ apt-get source pg-repack # prep test env $ cd pg-repack-1.3.4/ $ mkdir /tmp/pg-repack-tablespace $ chown postgres:postgres /tmp/pg-repack-tablespace # these two commands you can iterate on when debugging $ service postgresql stop $ pg_buildext installcheck On Ubuntu you'd need the ppa [2] I currently test on to trigger it - also Yakkety is the only releases which has pr-repack atm. [1]: https://ci.debian.net/packages/p/pg-repack/unstable/amd64/ [2]: https://launchpad.net/~ci-train-ppa-service/+archive/ubuntu/2470 -- Christian Ehrhardt Software Engineer, Ubuntu Server Canonical Ltd