Updating a PostgreSQL cluster

• Why did my cluster switch to the Updating status during an unscheduled backup?

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

• How can I change the number of connections available for a user?

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

• 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 do I take a cluster out of read-only mode?

Why did my cluster switch to the Updating status during an unscheduled backup?Why did my cluster switch to the Updating status during an unscheduled backup?

Once the backup process is started, the cluster changes its status to Updating. You cannot cancel this operation. Please wait for it to complete.

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 value is 50. The minimum value 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 do this 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 required disk type when configuring the new cluster.

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

Cluster management via SQL commands has certain restrictions. 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 via SQL. Managed Service for PostgreSQL clusters only support database creation via Yandex Cloud interfaces.

How to take a cluster out of read-only mode?How to take a cluster out of read-only mode?

Follow the steps described in Recovering a cluster from read-only mode and Manually disable read-only mode for the cluster.