Get started with Managed PostgreSQL

Create a single-node database, read its password, connect with psql over TLS, and delete it again, in about ten minutes.

Last updated 18 November 2026View as Markdown

Replace orders with a name of your own and ewdb-0123456789ab with the id the create returns.

Prerequisites

  • Permission for rds:CreateDBInstance, rds:DescribeDBInstances and rds:DeleteDBInstance, and secrets:GetSecretValue to read the password.
  • For the CLI steps, the dcloud CLI, signed in. For the connection, psql on your computer.

Step 1: Create a database

A single node on a performance-2, reachable from the internet so that you can connect from your computer. You pay for the database from now on.

  1. Open Postgres, then choose Create Postgres database.
  2. For Name, enter orders.
  3. Under Size, for Nodes, choose Single node.
  4. For Machine type, choose performance-2.
  5. Under Security, select Reachable from the internet.
  6. Choose Create database.

The database page opens with the status creating.

The status changes from creating to available within a few minutes. Each step appears on the database's Activity.

Step 2: Read the master password

  1. On the database page, choose Connection.
  2. Under Master password, choose Reveal.

Reading a secret value is recorded in the audit log.

Step 3: Connect

The Connection tab shows the connection strings. The CLI downloads the platform's CA and runs psql with it, so verify-full checks that you reach your own database:

dcloud rds exec -- psql "postgresql://admin:<password>@<endpoint>:6432/appdb?sslmode=verify-full"

admin and appdb are the defaults for the master user and the first database. Run SELECT version(); to see the server answer.

Clean up

Delete the database so that you stop paying for it.

  1. On the database page, choose Danger zone.
  2. Under Delete this database, clear Take a final backup and keep the backups for N days.
  3. Choose Delete database.
  4. Enter the database name, and choose Delete database.

The machine, its volume, its address and its backups are removed.

Next steps

Did this page help you?