This topic describes how to manually pause and resume an AnalyticDB for PostgreSQL instance. This way, you can pause and resume your instance based on your business requirements to reduce costs.

Prerequisites

  • A pay-as-you-go instance is created.
  • The instance is in automatic Serverless mode or elastic storage mode.
  • To pause an instance, the instance must be in the Running state.
  • To resume an instance, the instance must be in the Paused state.

Precautions

  • 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 computing fees and storage fees. The following table describes whether you are charged for computing fees and storage fees while an instance is in different instance states. For more information about the prices, see Pricing.

Instance stateComputing feeStorage fee
PausingChargedCharged
PausedFree of chargeCharged
IdleFree of chargeCharged
ResumingFree of chargeCharged
RunningChargedCharged
Note While an AnalyticDB for PostgreSQL instance in Serverless mode is in the Pausing or Running state, you are billed for computing resources per second.

Pause an instance

  1. Log on to the AnalyticDB for PostgreSQL console.
  2. In the upper-left corner of the console, select the region where the instance resides.
  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.
    The instance state changes to Pausing. After the instance is paused, the instance state changes to Paused.
    Note It takes 10 to 15 minutes to pause an instance.

Resume an instance

  1. Log on to the AnalyticDB for PostgreSQL console.
  2. In the upper-left corner of the console, select the region where the instance resides.
  3. Find the instance that you want to resume and choose More > Resume Instance in the Actions column.
  4. In the message that appears, click OK.
    The instance state changes to Resuming. After the instance is resumed, the instance state changes to Running.
    Note It takes about 15 minutes to resume an instance.