Create or restore a PostgreSQL Managed Database

Provision a PostgreSQL Managed Database

Use this operation to create a new PostgreSQL Managed Database.

• Restricted users need the add_databases user grant.

• New instances can take 10 to 15 minutes to deploy.

• All Managed Databases include automatic, daily backups. Up to seven backups are automatically stored for each Managed Database, providing restore points for each day of the past week.

• All Managed Databases include automatic updates, which apply security patches to the underlying operating system of the PostgreSQL Managed Database. Configure the maintenance window for these updates with the Update a managed PostgreSQL database operation.

• If your database cluster is configured with a single node, downtime occurs during maintenance updates. Adjust the window to match a time that's the least disruptive to your application and users. Also consider upgrading to a high availability plan to avoid any maintenance downtime.

• Major upgrades are optional until the service reaches end of service, and can be done in place.

Restore a PostgreSQL Managed Database

Do this by creating a fork from a backup. A user needs read_write access to the database, and its status can be active, degraded, or failed.

📘

Restoring from a backup creates a second running cluster, which incurs billing. Delete the first cluster after the restore is complete, to avoid this billing.

​

linode-cli databases postgresql-create \
  --label example-db \
  --region us-east \
  --type g6-dedicated-2 \
  --cluster_size 3 \
  --engine postgresql/13.2 \
  --ssl_connection true \
  --allow_list 203.0.113.1 \
  --allow_list 192.0.1.0/24

<https://techdocs.akamai.com/cloud-computing/docs/getting-started-with-the-linode-cli>

databases:read_write

<https://techdocs.akamai.com/linode-api/reference/get-started#oauth>