Modifying your cluster

You can modify your cluster by modifying its configuration settings.

You can also modify your cluster by installing Postgres extensions. See Postgres extensions for more information.

Modify your cluster's configuration settings

1. Sign in to the Console.

2. From the Clusters page, select the name of the cluster you want to edit.

3. From the top-right corner of the Cluster Info panel, select Edit Cluster.

4. You can modify the following settings on the corresponding tab of the Edit Cluster page.

   Note

   Any changes made to the cluster's instance type, volume type, or volume properties aren't automatically applied to replica settings. To avoid lag during replication, ensure that replica instance and storage types are at least as large as the source cluster's instance and storage types. See Modify a faraway replica.

   Settings	Tab	Notes
   Cluster type	Cluster Info	You can't switch from a single-node cluster or a high-availability cluster to a distributed high-availability cluster or vice versa.
   Number of replicas (for a high-availability cluster)	Cluster Info	—
   Cluster name and password	Cluster Settings	—
   Instance type	Cluster Settings	Changing the instance type can incur higher cloud infrastructure charges.
   Volume type	Cluster Settings	You can't switch between the io2 and io2 Block Express volume types in an AWS cluster.
   Volume properties	Cluster Settings	It can take up to six hours to tune IOPS or resize the disks of your cluster because AWS requires a cooldown period after volume modifications, as explained in Limitations. The volume properties are disabled and can't be modified while this is in progress.
   Networking type (public or private)	Cluster Settings	If you're using Azure and previously set up a private link and want to change to a public network, you must remove the private link resources before making the change.
   Nodes (for a distributed high-availability cluster)	Data Groups	After you create your cluster, you can't change the number of data nodes.
   Database configuration parameters	DB Configuration	If you're using faraway replicas, only a small subset of parameters are editable. These parameters need to be modified in the replica when increased in the replica's source cluster. See Modify a faraway replica for details.
   Retention period for backups	Additional Settings	—
   Custom maintenance window	Additional Settings	Set or modify a maintenance window in which maintenance upgrades occur for the cluster. See Maintenance.
   Read-only workloads	Additional Settings	Enabling read-only workloads can incur higher cloud infrastructure charges.
   PgBouncer	Additional Settings	Enabling PgBouncer incurs additional infrastructure costs that depend on your cloud provider. See PgBouncer costs.
   Identity and Access Management (IAM) Authentication	Additional Settings	Turn on the ability to log in to Postgres using AWS IAM credentials. You must then run a command to add each user’s credentials to a role that uses IAM authentication in Postgres. See IAM authentication for Postgres.
   Superuser access	Additional Settings	Disabling the option removes superuser access for edb_admin, but any other superusers existing in the database retain their superuser privileges.

5. Save your changes.

   Note

   Saving changes might require restarting the database.

Modify a data group

You can modify the data groups in your distributed high-availability cluster by editing the configuration settings.

1. Sign in to the Console.

2. On the Clusters page, select the data group you want to edit. Data groups appear under the cluster they reside in.

3. Select Edit next to the data group.

4. Edit the cluster settings in the Data Groups tab. See the table in Modify your cluster configuration settings.

5. Select Save.

6. In the popup window, confirm your changes.