3 ms·
Great timing. Just 2 weeks ago I produced what to my knowledge is the first full-source-bootstrapped, deterministic, and OCI-native PostgreSQL package. Built a
by lrvick 3y ago
Great timing. Just 2 weeks ago I produced what to my knowledge is the first full-source-bootstrapped, deterministic, and OCI-native PostgreSQL package.
Built and signed by multiple people and entirely distro agnostic. You can even build with your pick of several OCI engines on several operating systems so maximally portable too.
If extensions are packaged similarly it will sure make my life easier integrating them.
If you are going to package with only one standard, OCI is the most portable and flexible choice today IMO.
https://codeberg.org/stagex/stagex/src/branch/main/packages/postgresql/Containerfile https://codeberg.org/stagex/stagex/src/branch/main/packages/...
- justinclift 3y ago> ... PostgreSQL package. Is it able to automatically upgrade people from older PG versions? If not, the MIT licensed code from here might be worth looking through and grabbing ideas from? :) https://github.com/pgautoupgrade/docker-pgautoupgrade https://github.com/pgautoupgrade/docker-pgautoupgrade Specifically the scripting here is the bulk of it, the majority of the other stuff is just the existing docker entrypoint code from the official Docker PG container: https://github.com/pgautoupgrade/docker-pgautoupgrade/blob/0d00eb8188d4f5d65ba5cda0953cee6a73c71227/docker-entrypoint.sh#L362-L558 https://github.com/pgautoupgrade/docker-pgautoupgrade/blob/0...
- justinclift 3y agoOh, you'll probably want to use "make install-world" rather than "make install". The "-world" version also includes many PG extensions when it runs, which is likely beneficial. :) https://codeberg.org/stagex/stagex/src/branch/main/packages/postgresql/Containerfile#L57 https://codeberg.org/stagex/stagex/src/branch/main/packages/...
- lrvick 3y agoGood call. Will get that into the next release