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?

• Can I create a database using SQL commands?

• How to recover a cluster from read-only mode?

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, e.g., given a cluster with "max_connections": 100, you can reserve a maximum of 85 connections per cluster host for users.

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

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

Can I change the an existing cluster's disk type?Can I change the an existing cluster's disk type?

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.

Can I create a database using SQL commands?Can I create a database using SQL commands?

No, you cannot create a database using SQL commands. In a Managed Service for PostgreSQL cluster, you can create databases only using Yandex Cloud interfaces.

How to recover a cluster from read-only mode?How to recover a cluster from read-only mode?

Follow the steps described in Recovering a cluster from read-only mode and Manually get the cluster out of the read-only mode.