Pausing or Resuming WAL Log Replay

Function

This API is used to pause or resume WAL replay on a read replica.

If WAL replay is paused but streaming replication is still in progress, WAL logs will continue to be received by the read replica and will eventually fill up the storage. This depends on how long the replay is paused for, how quick WAL logs are generated, and how much available storage there is in your instance.

• Before calling an API, you need to understand the API in Authentication.

Constraints

• To use this function, contact customer service to obtain required permissions.
• This function is only available to read replicas of RDS for PostgreSQL 12 and later versions.

URI

• URI format

  PUT /v3/{project_id}/instances/{instance_id}/log-replay/update

• Parameter description

  Table 1 Parameters

  Parameter	Mandatory	Description
  project_id	Yes	Project ID of a tenant in a region. For details about how to obtain the project ID, see Obtaining a Project ID.
  instance_id	Yes	Instance ID.

Request

• Parameter description

  Table 2 Parameters

  Parameter	Mandatory	Type	Description
  pause_log_replay	Yes	String	Wether to pause or resume WAL replay. true: Pause WAL replay. false: Resume WAL replay. Other values or left blank: No operation is performed.

• URI example

  PUT https://rds.ap-southeast-1.myhuaweicloud.com/v3/0483b6b16e954cb88930a360d2c4e663/instances/49b9dd1d6f464ba4bc91df5cbd2e52ebin03/log-replay/update

• Example request

  Pause WAL replay on a read replica.

  { 
     "pause_log_replay" : "true"
   }

Response

• Normal response

  Table 3 Parameters

  Parameter	Type	Description
  message	String	Returns operate successfully if the invoking is successful.

• Example normal response

  { 
     "message" : "operate successfully" 
   }

• Abnormal response

  For details, see Abnormal Request Results.

Status Code

• Normal

  200

• Abnormal

  For details, see Status Codes.

Error Code

For details, see Error Codes.