Validated on 31 Jan 2024 • Last edited on 13 Feb 2024
PostgreSQL is an open source, object-relational database built with a focus on extensibility, data integrity, and speed. Its concurrency support makes it fully ACID-compliant, and it supports dynamic loading and catalog-driven operations to let users customize its data types, functions, and more.
You can update your database engine’s parameters with the CLI or API. This allows you to edit dozens of parameters that you otherwise couldn’t in the control panel. For a full list of the parameters you can edit, see our API reference, beneath the REQUEST BODY SCHEMA section, click config, and then click the postgres option.
Note
To ensure database stability, you may be unable to edit certain parameters. In this case, contact support.
Update a Database’s Configuration Using the CLI
How to update a database's configuration using the DigitalOcean CLI
To update a database's configuration via the command-line, follow these steps:
Use the token to grant doctl access to your
DigitalOcean account.
doctl auth init
Finally, update a database's configuration with
doctl databases configuration update. The basic usage looks
like this, but you'll want to read the usage docs for more details: