Creating a PostgreSQL Database
This page covers the configuration specific to PostgreSQL — its Database Mode and any engine-specific settings shown below. The rest of the creation flow — opening the wizard, namespace and name, version, machine profile, storage, and optional features — is the same for every engine and is documented in Common Steps.
Database Mode
Select the topology under Database Mode. Three modes are available:
- Standalone — A single-node PostgreSQL instance.
- Cluster — A primary with one or more streaming replicas for high availability. Set the Number of Replicas.
- RemoteReplica — A replica that streams from an external/primary PostgreSQL for cross-cluster replication.
When Cluster is selected, configure replication behaviour:
| Field | Description |
|---|---|
| Number of Replicas | Number of standby replicas (e.g., 3). Required. |
| Standby Mode | Hot (replicas accept read queries) or Warm (replicas stay in standby, no reads). |
| Streaming Mode | Synchronous (commit waits for replica acknowledgement) or Asynchronous (commit does not wait). |
Create a PostgreSQL Database
- Open the wizard and select PostgreSQL — see Getting Started and Select a Database Type.
- Set the namespace and name.
- Pick the database version and the Database Mode described above, then set the machine profile and storage — see Configure the Database.
- Optionally configure Advanced Configuration (labels, deletion policy, credentials, point-in-time recovery) and Additional Options (monitoring, backup, TLS, gateway).
- Click Deploy.