Gluttony-Cluster/docs/technical/postgresql.md

Postgresql

Postgresql is the rdbms that I use.

Use the postgresql namespace, and add the helm chart.

Custom container image

One thing that is different from the vanilla install is the use of my custom postgresql image.

It just contains pgvector, originally for use with Immich.

Password setup

For some reason if you pass the password you want in the environment using a sealed secret in the helm chart, there must be some encoding thing happening or something, but it will not accept the password. Therefore, the password is hardcoded into the chart, then updated with an alter command. Command looks something like this.

ALTER USER postgres SET password = 'mysecurepassword'