jfrog / charts

JFrog official Helm Charts
https://jfrog.com/integration/helm-repository/
Apache License 2.0
259 stars 448 forks source link

jfrog-platform example breaks on psql 15+ #1900

Open isaac-s opened 4 months ago

isaac-s commented 4 months ago

Is this a request for help?: No


Is this a BUG REPORT or FEATURE REQUEST? (choose one): Bug report

Version of Helm and Kubernetes: N/A

Which chart: jfrog/jfrog-platform

Which product license (Enterprise/Pro/oss): N/A

JFrog support reference (if already raised with support team): N/A

What happened:

The example here:

https://github.com/jfrog/charts/blob/master/examples/jfrog-platform/docs/external-postgres.md

— is insufficient for PostgreSQL 15+, because it assumes that the public schema is globally writable, which isn't true for 15+:

https://www.crunchydata.com/blog/be-ready-public-schema-changes-in-postgres-15

Need to add commands that grant the created users access to the public schema, or to avoid using the public schema at all.