PostgreSQL

Postgres Database is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

Create a Postgres Database#

All Postgres servers are 100% dedicated to your environment.

  1. Click on the Create Service button at the top right of your environment.
  2. Click on the From Catalog tab at the top right.
  3. Select the Postgres option in the list.
  4. Enter or generate your desired Username Password and Root Password values.
  5. Click Deploy at the top right and wait until the release is successful.
  6. Once deployed, click on the Access Tab to read the access related information.

Access tab

Access Your Postgres Database#

You may only access your Postgres Instance from services running in the same environment. Learn more about how to connect to your Postgres Database under the Access Tab.

Postgres Advanced Options#

Replication#

Enabling replication turns on a separate endpoint for Postgres readonly instances. You can enable replication under the Configurations tab when Creating a Postgres service. You may not enable this after the service has been created. It's recommended to enable Replication in Production environments or any environments you wish to decrease the chances of downtime. Read more about read replicas here.

(Storage) Persistence#

Postgres SQL has an optional (Storage) Persistence and Volume Size options available under the Advanced Options Tab.

Postgres Advanced