Update Patroni

[ancharb]

Describe the task
Update patroni to latest LTS version

Purpose
Resolve security issues

Acceptance Criteria

• update patroni

[ancharb]

Patroni is using this helm chart: https://github.com/bcgov/nr-patroni-chart

Which uses a custom Patroni image that hasn't been updated since Jan 2024.

We may be able to replace with this: https://github.com/patroni/patroni/blob/master/kubernetes/patroni_k8s.yaml

[ancharb]

From earlier attempt to update Patroni:
Patroni is proving challenging. It looks like our helm chart is a government one, and it uses an image from a government repository. It seems like we're already using the latest version in that repo (which is honestly hard to figure out exactly what version that is), but that was published Jan 2024. I looked into the official Patroni Kubernetes configs, but I can't get them to work. It might be a big job. Should we maybe put this off? We were originally planning to just update Metabase.

Also, I'm not sure why we're using a custom image. Maybe there is some policy-related issue?