charts icon indicating copy to clipboard operation
charts copied to clipboard

jfrog-platform example breaks on psql 15+

Open isaac-s opened this issue 7 months ago • 0 comments

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.

isaac-s avatar Jul 10 '24 21:07 isaac-s