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
Sign in to the BigAnimal portal.
From the Clusters page, select the name of the cluster you want to edit.
Select Edit Cluster from the top right corner of the Cluster Info panel.
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 are not automatically applied to its replicas' settings. To avoid lag during replication, ensure that your replicas' 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 Tab You can't switch from a single-node cluster or a high-availability cluster to an extreme-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 cannot 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 cool down period after volume modifications as explained in the Limitations section. The volume properties are disabled and cannot be modified while this is in progress. Networking type (public or private) Cluster Settings If you are using Azure and previously setup a private link and want to change to a public network, you must remove the private link resources before making the change. Nodes (for an extreme-high-availability cluster) Data Groups — Database configuration parameters DB Configuration If you are using faraway replicas, only a small subset of parameters are editable. These parameters need to 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 — Read-only workloads Additional Settings Enabling read-only workloads can incur higher cloud infrastructure charges. Custom maintenance window Additional Settings Set or modify a maintenance window in which maintenance upgrades occur for the cluster. See Maintenance. 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. Save your changes.
Note
Saving changes might require a database restart.
Modify a data group
You can modify the data groups in your extreme-high-availability cluster by editing the configuration settings.
Sign in to the BigAnimal portal.
On the Clusters page, select the data group you want to edit. Data groups appear under the cluster they reside in.
Select Edit next to the data group.
Edit the cluster settings in the Data Groups tab. See the table in Modify your cluster.
Select Save.
In the popup window, confirm your changes.