LogoLogo
WebsiteGarden Core
Main
Main
  • Welcome!
  • 🌳Getting Started
    • Adding Your First Project
  • 🌺Features
    • Live Mode
    • Insights
    • Secrets
    • One-click Preview Environments
    • Automatic Environment Cleanup
    • User Groups, Roles and Permissions
    • Cloud Workflows
    • Service Accounts
    • Cloud Builder
  • 🌿Guides
    • Setting Up a GitHub App
    • Setting Up a GitLab App
    • Authenticating to Cloud Providers
    • Authentication via SAML
  • 💐Cloud
    • Requirements
  • 🌻Enterprise (Self-Hosted)
    • Requirements
    • Installation
    • Updating Garden Enterprise
    • Vault
    • PostgreSQL Configuration
    • Creating KMS Keys
    • Creating an AWS Load Balancer
    • Monitoring Services
    • Environment Configuration
    • Updating the Admin Console
  • 🌹Misc
    • Release Notes
    • FAQ
    • Troubleshooting
Powered by GitBook
On this page

Was this helpful?

  1. Enterprise (Self-Hosted)

PostgreSQL Configuration

PreviousVaultNextCreating KMS Keys

Last updated 2 years ago

Was this helpful?

Garden Enterprise users will 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 for more information on granting privileges.

You'll find the exact values you need to have at during the Garden Enterprise installation in the 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

🌻
need a PostgreSQL database
official Postgres docs
database section