PostgreSQL Configuration
Last updated
Last updated
Garden Enterprise users will need a PostgreSQL database that is accessible from other Garden Enterprise in-cluster services.
We recommend using cloud managed databases which in general should come with the appropriate settings and permissions out of the box.
In case you need to configure these yourself, you'll find a detailed list of required settings and permissions in the table below. See also the official Postgres docs for more information on granting privileges.
You'll find the exact values you need to have at during the Garden Enterprise installation in the database section of our Environment Configuration guide.
Your PostgreSQL database will need to have the uuid-ossp
extension installed. This is default for most cloud managed PostgreSQL databases. In case you need to install it manually, you can do so by running the following as an admin user in the database's psql
shell:
Furthermore, the following settings and permissions need to be applied at the database, schema, and user level:
Setting | Value |
---|---|
Encoding
UTF8
Database Privileges
CONNECT
, CREATE
Schema
public
Schema Privileges
USAGE
Table Privleges
INSERT
, DELETE
, SELECT
, UPDATE
, REFERENCES
, TRUNCATE
, TRIGGER