While the Debian archive only contains a single PostgreSQL version per distribution, upstreams supports five concurrent branches plus the devel/beta versions. The apt.postgresql.org repository extends the Debian packaging of the PostgreSQL server packages to cover the full cross product of all branches times seven Debian and Ubuntu releases times currently two architectures. On top of that, various PostgreSQL extension packages are built.
This talk is about the lessons learned while maintaining this package set and how automated testing helps to ensure high quality.
Ingredients are pg_regress, jenkins, jenkins-debian-glue, autopkgtest, dpkg and reprepro tweaks, and automation tools from postgresql-common.