Modifying your cluster

Suggest edits

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.

    SettingsTabNotes
    Cluster typeCluster InfoYou 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 passwordCluster Settings
    Instance typeCluster SettingsChanging the instance type can incur higher cloud infrastructure charges.
    Volume typeCluster SettingsYou can't switch between the io2 and io2 Block Express volume types in an AWS cluster.
    Volume propertiesCluster SettingsIt 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 SettingsIf 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 GroupsAfter you create your cluster, you can't change the number of data nodes.
    Database configuration parametersDB ConfigurationIf 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 backupsAdditional Settings
    Custom maintenance windowAdditional SettingsSet or modify a maintenance window in which maintenance upgrades occur for the cluster. See Maintenance.
    Read-only workloadsAdditional SettingsEnabling read-only workloads can incur higher cloud infrastructure charges.
    PgBouncerAdditional SettingsEnabling PgBouncer incurs additional infrastructure costs that depend on your cloud provider. See PgBouncer costs.
    Identity and Access Management (IAM) AuthenticationAdditional SettingsTurn 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 accessAdditional SettingsDisabling the option removes superuser access for edb_admin, but any other superusers existing in the database retain their superuser privileges.
  1. 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.


Could this page be better? Report a problem or suggest an addition!