Updating a PostgreSQL cluster

• Why did the cluster change its status to Updating during an unscheduled backup?

• Can I create two PostgreSQL databases at the same time?

• Can I change the number of connections available to a user?

• Can I change the class of an existing host (standard, memory-optimized, burstable)?

• Can I change the disk type in an existing cluster?

• Can I manage a cluster using SQL commands?

• Why cannot I stop a cluster?

Why did the cluster change its status to during an unscheduled backup?Why did the cluster change its status to Updating during an unscheduled backup?

The cluster changes its status to Updating right after the backup process is launched. You cannot cancel this operation. Wait for it to complete instead.

The time this operation is performed depends on a number of factors, such as DB size, cluster configuration, and the nature of data being stored. The average speed when recovering a cluster from a backup is about 100 Mbps.

Can I create two PostgreSQL databases at the same time?Can I create two PostgreSQL databases at the same time?

You cannot apply multiple transactions to a cluster at the same time. It is an architectural feature of the technologies utilized by Yandex Cloud.

Can I change the number of connections available to a user?Can I change the number of connections available to a user?

Yes, you can. To do this, change the values of the relevant settings:

• Conn limit: Maximum number of host connections per user. The default is 50. The minimum is 10.
• Max connections: Maximum number of connections reserved for all users. The default value is 200 × <number_of_vCPUs_per_host>. You have to keep in mind that this number includes 15 service connections: for instance, if a cluster has "max_connections": 100, you are only able to reserve at most 85 connections per cluster host for users.

Can I change an existing host's class (standard, memory-optimized, burstable)?Can I change an existing host's class (standard, memory-optimized, burstable)?

Yes, you can by following the procedure in Changing cluster settings.

Can I change the disk type in an existing cluster?Can I change the disk type in an existing cluster?

Yes, you can. To do this, restore the cluster from a backup and specify the desired disk type when configuring the new cluster.

Can I manage a cluster using SQL commands?Can I manage a cluster using SQL commands?

There are some restrictions for cluster management using SQL commands. For more information, see SQL command limits.

Why cannot I stop a cluster?Why cannot I stop a cluster?

Error message:

ERROR: rpc error: code = FailedPrecondition desc = Cluster has no backups

A cluster that has no backups cannot be stopped. To fix the error and stop the cluster, create its backup.