Discuss with expertTry it for free
© 2026 Direct Cursus Technology L.L.C.

Updating PostgreSQL cluster settings

Written by
Updated at April 8, 2026
View in Markdown

If you have a PostgreSQL cluster in your project, you can update its settings.

  1. Open the PostgresqlCluster resource, e.g., using the open postgresqlcluster.yaml command.

  2. Open the resource file and edit the following properties:

    • metadata.name: Cluster name.
    • metadata.namespace: Project name.
    • spec.instances: Number of cluster replicas.
    • spec.storage.size: Storage size. You can only increase it.
    • spec.storage.autoScaling.enabled: Enabling automatic storage expansion.
    • spec.storage.autoScaling.maxSize: Maximum storage size.
    • spec.storage.autoScaling.standardIncreasePercent: Storage expansion percentage.
    • spec.storage.autoScaling.resizeTriggerPercent: Storage usage percentage threshold that triggers storage expansion.
    • spec.storage.readOnlyTriggerPercent: Disk usage percentage to switch to read-only mode.
    • spec.enableSuperuserAccess: You can disable superuser access while editing.
    • spec.resources: Pod resource limits.
    • spec.postgresConfiguration: PostgreSQL configuration.
    • spec.poolers.[ro|rw|r].port: Connection pooler port settings.
    • spec.poolers.[ro|rw|r].instances: Number of connection pooler replicas.
    • spec.poolers.[ro|rw|r].type: Cluster type for the connection pooler, e.g., ClusterIP.
    • spec.poolers.[ro|rw|r].odyssey.poolMode: Operation mode of the database connection pool (session or transaction).
    • spec.backup: Backup settings.
    • spec.deletionProtection: Deletion protection. If set to true, you cannot delete the cluster until the protection is disabled.

  3. Apply the manifest: kubectl apply -f postgresqlcluster.yaml -n <project name>. Optionally, you can specify the project name in the metadata.namespace resource property and skip it in the command.

  1. If you have not opened a project yet, select one.

  2. In the left-hand menu, select PostgreSQL Clusters.

  3. Select the cluster.

  4. Click Edit.

  5. Edit the following fields:

    • Cluster name. Only use lowercase letters, numbers, and hyphens.
    • Number of instances: Number of cluster replicas.
    • Computing resources, where Limits is the upper limit and Requests is the lower limit.
    • Storage: Increase the storage size or enable automatic storage expansion.
    • Connection pooler: Handles writes and reads; used for all data-modifying operations and critical transactions.
    • Backups: Settings for creating the database backup in an S3 bucket.
    • Deletion protection: Toggle. You cannot delete the cluster until the protection is disabled.

  6. Click Save.

This is it, your cluster settings have been updated.

Previous
Creating a PostgreSQL cluster
Next
Creating a user