API

Create or restore a PostgreSQL Managed Database

post https://api.linode.com//databases/postgresql/instances

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.

  • When you create a new PostgreSQL Managed Database, our partner Aiven automatically enables disk encryption on each cluster.

  • 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.

  • A successful request triggers a database_create event.

  • You can create a PostgreSQL Managed Database in a Virtual Private Cloud (VPC) using the private_network object in the request. This support is in beta. Talk to your Akamai account team for more details.

    📘

    Currently, VPC subnets associated with Managed Database instances don't automatically block outbound connections outside the subnet. To limit network exposure, you should configure Cloud Firewall rules to explicitly deny outbound connections beyond the intended subnet. For more details on configuring rules, see the Cloud Firewall documentation.

Restore a PostgreSQL Managed Database

Include the fork object in the request to target a backed-up database. Your user needs read_write access to the target 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 \
  --engine_config.shared_buffers_percentage 41.5 \
  --engine_config.pg.autovacuum_analyze_scale_factor 0.0 \
  --engine_config.pg.autovacuum_vacuum_cost_delay 60 \
  --engine_config.pg.pg_partman_bgw.interval 3600 \
  --engine_config.pg.pg_partman_bgw.role myrolename \
  --engine_config.pglookout.max_failover_replication_time_lag 60 \
  --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>
Language
Credentials
Click Try It! to start a request and see the response here!