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 operation’s duration depends on a number of factors, including database size, cluster configuration, and the nature of the stored data. The average cluster restoration speed is approximately 100 MB/s.

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

You cannot perform multiple cluster operations simultaneously due to architectural constraints of the technologies used in Yandex Cloud.

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

You can change the number of connections by updating the following 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>. Note that this number includes 15 system connections. For example, with "max_connections": 100, you can reserve no more than 85 user connections per cluster host.

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

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.