Update a managed PostgreSQL database

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

Update a Managed PostgreSQL Database.

Requires read_write access to the Database.

The Database must have an active status to perform this operation.

Updating addresses in the allow_list overwrites any existing addresses.

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

  • Note. Updates to the allow_list may take a short period of time to complete, making this operation inappropriate for rapid successive updates to this property.

All Managed Databases include automatic patch updates, which apply security patches and updates to the underlying operating system of the Managed PostgreSQL Database. The maintenance window for these updates is configured with the Managed Database's updates property.

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

linode-cli databases postgresql-update 123 \
  --label example-db \
  --allow_list 203.0.113.1 \
  --allow_list 192.0.1.0/24 \
  --type g6-standard-1 \
  --updates.frequency monthly \
  --updates.duration 3 \
  --updates.hour_of_day 12 \
  --updates.day_of_week 4 \
  --updates.week_of_month 3

<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!