pg_partman is an extension to create and manage both time-based and
serial-based table partition sets. Native partitioning in PostgreSQL
10 is supported as of pg_partman v3.0.1 and much more extensively as
of 4.0.0 along with PostgreSQL 11.
I opted to not install the background worker, since the base image already has pg_cron.
Size changes
This appears to add about 20 MB to the base image size, when building as a separate layer:
$ docker image ls | grep cimg/post
cimg/postgres 12.9-partman 586ec1dac200 About an hour ago 2.1GB
cimg/postgres 12.9 37dfce59e2e3 18 months ago 2.08GB
Reasons
I would like to use Partman for local development and in CI so that my schema can match the production version.
Checklist
Please check through the following before opening your PR. Thank you!
[x] I have made changes to the Dockerfile.template file only
[x] I have not made any manual changes to automatically generated files
Description
This adds PG Partman support to the base image.
From https://github.com/pgpartman/pg_partman:
I opted to not install the background worker, since the base image already has pg_cron.
Size changes
This appears to add about 20 MB to the base image size, when building as a separate layer:
Reasons
I would like to use Partman for local development and in CI so that my schema can match the production version.
Checklist
Please check through the following before opening your PR. Thank you!
Dockerfile.templatefile only