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>