Create a managed PostgreSQL database

This operation is currently only available for customers who already have an active Managed Database.

Provision a Managed PostgreSQL Database.

Restricted Users must have the add_databases grant to use this operation.

New instances can take approximately 15 to 30 minutes to provision.

The allow_list is used to control access to the Managed Database.

  • IP addresses and ranges in this list can access the Managed Database. All other sources are blocked.

  • If 0.0.0.0/0 is a value in this list, then all IP addresses can access the Managed Database.

  • Entering an empty array ([]) blocks all connections (both public and private) to the Managed Database.

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 patch updates, which apply security patches and updates to the underlying operating system of the Managed PostgreSQL Database during configurable maintenance windows.

  • If your database cluster is configured with a single node, you will experience downtime during this maintenance window when any updates occur. It's recommended that you adjust this window to match a time that will be the least disruptive for your application and users. You may also want to consider upgrading to a high availability plan to avoid any downtime due to maintenance.

  • The database software is not updated automatically. To upgrade to a new database engine version, consider deploying a new Managed Database with your preferred version. You can then migrate your databases from the original Managed Database cluster to the new one.

  • To modify update the maintenance window for a Database, run the Update a managed PostgreSQL database operation.

linode-cli databases postgresql-create \
  --label example-db \
  --region us-east \
  --type g6-dedicated-2 \
  --cluster_size 3 \
  --engine postgresql/13.2 \
  --encrypted false \
  --ssl_connection false \
  --replication_type asynch \
  --replication_commit_type local \
  --allow_list 203.0.113.1 \
  --allow_list 192.0.1.0/24

<https://www.linode.com/docs/products/tools/cli/get-started/>
databases:read_write

<https://techdocs.akamai.com/linode-api/reference/get-started#oauth>
Language
Authorization
Click Try It! to start a request and see the response here!