Updating a Sharded PostgreSQL cluster

Navigate to the folder dashboard and select Yandex Managed Service for Sharded PostgreSQL.

Select the cluster and click Edit in the top panel.

Under Basic parameters:

• Edit the cluster name and description.
• Delete or add new labels.

Under Network settings, select security groups for the cluster.

Update the computing resource configuration:

• For standard sharding, update the infrastructure host configuration under Infrastructure.
• For advanced sharding, update the router host configuration under Router. If employing a coordinator, update the coordinator host configuration under Coordinator.

To update your computing resource configuration:

1. Change platform in the Platform field.
2. Change Type for the VM the hosts are deployed on.
3. Change Host class.
4. Under Storage, change disk type and storage size.

Change additional cluster settings:

• Password from Sharded PostgreSQL console. It may be from 8 to 128 characters long.

• Min. logging level: Execution log will register logs of this or higher level. The available levels are DEBUG, INFO, WARN, ERROR, FATAL, and PANIC. The default level is INFO.

• Backup start time (UTC): Time interval during which the cluster backup starts. Time is specified in 24-hour UTC format. The default time is 22:00 - 23:00 UTC.

• Retention period for automatic backups, days: Automatic backups will be stored for this many days. The default value is seven days.

• Maintenance window: Maintenance window settings:

  • To enable maintenance at any time, select arbitrary (default).
  • To specify the preferred maintenance start time, select by schedule and specify the desired day of the week and UTC hour. For example, you can choose a time when the cluster is least loaded.

  Maintenance operations are carried out both on enabled and disabled clusters. They may include updating the DBMS, applying patches, and so on.

• DataLens access: Enables you to analyze cluster data in Yandex DataLens.

• WebSQL access: Enables SQL queries against cluster databases from the Yandex Cloud management console using Yandex WebSQL.

• Access from Data Transfer: Enable this option to allow cluster access from Yandex Data Transfer.

• Deletion protection: Manages cluster protection against accidental deletion.

  Even with cluster deletion protection enabled, one can still delete a user or database or connect manually and delete the database contents.

Click Save changes.