Configure PostgreSQL on TurboStack

Enable Percona PostgreSQL on a TurboStack host, pick a version, and optionally tune shared buffers, listen addresses, or grant extra access.

Enable PostgreSQL on a host, choose a version, and let TurboStack auto-tune sizing for apps like Odoo and Medusa.

The PostgreSQL panel on a host's Services tab, enabled, showing the Client only toggle, the version field, 3rd party Extensions, and Advanced Settings expanded to show Listen Addresses and Shared Buffers
The PostgreSQL panel on a host's Services tab, enabled, showing the Client only toggle, the version field, 3rd party Extensions, and Advanced Settings expanded to show Listen Addresses and Shared Buffers

Where to configure it

PostgreSQL is a host-level service. Open the host, go to its Services tab, and select PostgreSQL. Enable it and pick the major version. Saving updates the host YAML and provisions Percona PostgreSQL on that host.

YAML configuration

Required

Key Meaning
postgresql_version The PostgreSQL major version to install, for example "17" (or newer).

Optional

Key Meaning
postgresql_shared_buffers Memory used for caching. Auto-tuned to the server by default - override only with measured evidence.
postgresql_listen_addresses The addresses PostgreSQL listens on, or ANY for every interface. Security-sensitive: keep it on localhost unless remote access is required.
postgresql_extra_access A list of host-based access rules for specific networks or hosts. Each entry is a mapping with type (for example host), database, user, address (a network range or host) and auth_method (for example scram-sha-256).
postgresql_extensions Extra extensions to install. Only vector, postgis, timescaledb and pg_stat_statements are accepted; any other name stops the deployment. 
postgresql_version: "17"

# Optional overrides
postgresql_shared_buffers: "2GB"          # leave unset to keep auto-tuning
postgresql_listen_addresses: "localhost"  # widen only when needed
postgresql_extra_access:
  - type: host
    database: all
    user: gitlab_db
    address: 10.0.0.0/8
    auth_method: scram-sha-256

Listening address

postgresql_listen_addresses takes an address, or the keyword ANY, which makes PostgreSQL listen on every interface the server has.

Common tasks

© 2026 Hosted Power — TurboStack