AnalyticDB for PostgreSQL:Manually pause and resume an instance

Prerequisites

• A pay-as-you-go AnalyticDB for PostgreSQL instance is created.

• The AnalyticDB for PostgreSQL instance is in Serverless manual scheduling mode or elastic storage mode.

  Note

  You do not need to manually pause and resume AnalyticDB for PostgreSQL instances in Serverless automatic scheduling mode, because the instances can be automatically paused and resumed based on traffic detection. If no traffic is detected, the instances automatically enter the idle state. You are not charged for computing resources when the instances are in the idle state.

• Before you pause an AnalyticDB for PostgreSQL instance, the instance is in the Running state.

• Before you resume an AnalyticDB for PostgreSQL instance, the instance is in the Paused state.

Usage notes

• After you initiate an instance pause, SQL statements that are being executed in the instance are terminated.

• After you initiate an instance pause, a snapshot backup is immediately performed on the instance.

• While an instance is in the Paused state, you cannot connect to the instance or execute SQL statements.

• While an instance is in the Paused state, you can only release the instance, restore data of the instance, or resume the instance.

• If an instance that has the data sharing feature enabled and shares its data is paused, the instances that have subscribed to the shared data can still consume the data but other instances cannot subscribe to the shared data.

Billing rules

The fees for using an AnalyticDB for PostgreSQL instance consist of the computing resource fee and the storage resource fee. The following table describes whether you are charged for the fees while an instance is in different states. For more information, see Pricing.

Pause an instance

1. Log on to the AnalyticDB for PostgreSQL console.
2. In the upper-left corner of the console, select a region.

3. Find the instance that you want to pause and choose More > Pause Instance in the Actions column.

4. In the message that appears, click OK.

   After you click OK, the status of the instance changes to Pausing. After the instance is paused, the status of the instance changes to Paused.

   Note

   The instance pause process requires 10 to 15 minutes to complete.

Resume an instance

1. Log on to the AnalyticDB for PostgreSQL console.
2. In the upper-left corner of the console, select a region.

3. Find the instance that you want to pause and choose More > Resume Instance in the Actions column.

4. In the message that appears, click OK.

   After you click OK, the status of the instance changes to Resuming. After the instance is resumed, the status of the instance changes to Running.

   Note

   The instance resume process requires approximately 15 minutes to complete.