PostgreSQL Configuration

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.

Settings

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:

CREATE EXTENSION "uuid-ossp";

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