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

  1. Sign in to the BigAnimal portal.

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

  3. Select Edit Cluster from the top right corner of the Cluster Info panel.

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

    SettingsTabNotes
    Cluster typeCluster Info TabYou 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 passwordCluster Settings
    Instance typeCluster SettingsChanging the instance type can incur higher cloud infrastructure charges.
    Volume typeCluster SettingsYou cannot 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 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 SettingsIf 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.
    Database configuration parametersDB ConfigurationIf 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 backupsAdditional Settings
    Read-only workloadsAdditional SettingsEnabling read-only workloads can incur higher cloud infrastructure charges.
    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.
  5. Save your changes.

    Note

    Saving changes might require a database restart.