CrunchyData / crunchy-containers

Containers for Managing PostgreSQL on Kubernetes by Crunchy Data
https://www.crunchydata.com/
Apache License 2.0
1.01k stars 328 forks source link

Add the orafce Extension #1466

Closed andrewlecuyer closed 2 years ago

andrewlecuyer commented 2 years ago

Adds the orafce extension to all Postgres container builds.

This increases the size of a PG container slightly:

REPOSITORY                                                         TAG                        IMAGE ID       CREATED          SIZE
# before
registry.developers.crunchydata.com/crunchydata/crunchy-postgres   ubi8-14.4-0                926adcbc25fb   13 days ago      902 MB
# after
util.io/crunchy-postgres                                           ubi8-14.4-fce1             c251291ea087   20 minutes ago   910 MB

[sc-15211]

andrewlecuyer commented 2 years ago

@benjaminjb in order to test this I built the container for all currently supported versions of Postgres, and verified that the extension can be successfully created:

# PG 10.21
$ kubectl exec -it -c database hippo-10-instance1-q7x5-0 -- psql
psql (10.21)
Type "help" for help.

postgres=# CREATE EXTENSION orafce;
CREATE EXTENSION

# PG 11.16
$ kubectl exec -it -c database hippo-11-instance1-x2gf-0 -- psql
psql (11.16)
Type "help" for help.

postgres=# CREATE EXTENSION orafce;
CREATE EXTENSION

# PG 12.11
$ kubectl exec -it -c database hippo-12-instance1-gwgj-0 -- psql
psql (12.11)
Type "help" for help.

postgres=# CREATE EXTENSION orafce;
CREATE EXTENSION

# PG 13.7
$ kubectl exec -it -c database hippo-13-instance1-5wnc-0 -- psql
psql (13.7)
Type "help" for help.

postgres=# CREATE EXTENSION orafce;
CREATE EXTENSION

# PG 14.4
$ kubectl exec -it -c database hippo-14-instance1-55xq-0 -- psql
psql (14.4)
Type "help" for help.

postgres=# CREATE EXTENSION orafce;
CREATE EXTENSION

We can therefore proceed with merging in order to get this into a build and do additional/more advanced testing.

Also, please note that this change is now reflected in the upgrade container as well (which I have also successfully built locally).