Creating a Sharded PostgreSQL cluster

In the management console, select the folder where you want to create a Sharded PostgreSQL cluster.

Select Yandex Managed Service for Sharded PostgreSQL.

Click Create cluster.

Under Basic parameters:

1. Give the cluster a name. The name must be unique within the folder.

2. Optionally, enter a description for the cluster.

3. Optionally, create labels:

   1. Click Add label.
   2. Enter a label in key: value format.
   3. Press Enter.

4. Select the environment where you want to create the cluster (you cannot change the environment once the cluster is created):

   • PRODUCTION: For stable versions of your apps.
   • PRESTABLE: For testing purposes. The prestable environment is similar to the production environment and likewise covered by the SLA, but it is the first to get new functionalities, improvements, and bug fixes. In the prestable environment, you can test the compatibility of new versions with your application.

5. Select the sharding type:

   • Standard: Cluster will consist only of infrastructure hosts.
   • Advanced: Cluster will consist only of router hosts and, optionally, coordinator hosts.

Under Network settings, select a network and security groups for the cluster.

Specify the computing resource configuration:

• For standard sharding, specify the infrastructure host configuration under Infrastructure.

• For advanced sharding, specify the router host configuration under Router.

  Optionally, under Coordinator, enable Coordinator and specify the coordinator host configuration.

To specify your computing resource configuration:

1. Select a platform in the Platform field.

2. Specify the Type of the VM to deploy hosts on.

3. Select Host class.

4. Under Storage, select the disk type and specify the storage size.

5. Under Hosts:

   1. Click Add host to add the required number of hosts to create together with the Sharded PostgreSQL cluster.

   2. Click and specify the following for each host:

      • Availability zone.
      • Subnet: By default, each host is created in a separate subnet.
      • Select Public access if the host must be accessible from outside Yandex Cloud.

   After creating a Sharded PostgreSQL cluster, you can add extra hosts to it if there are enough folder resources available.

Under Database, specify the database parameters:

• DB name. Acceptable length is from 1 to 63 characters. Can contain lowercase and uppercase Latin letters, numbers, underscores, and hyphens.

• Username. Acceptable length is from 1 to 63 characters. Can contain lowercase and uppercase Latin letters, numbers, underscores, and hyphens, but can't start with a hyphen.

• User password. It may be from 8 to 128 characters long.

Configure additional cluster settings, if required:

• 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 Create cluster.