RDS for PostgreSQL
RDS for PostgreSQL
RDS for PostgreSQL
Document
What's new
Product announcement
Overview
Billing
Quick start
User guide
Managing instances
Modifying the specification
Managing tags
Managing connections
Connecting to an instance
Managing connection endpoints
Service availability
Managing accounts
Managing databases
Managing schemas
Monitoring and alerts
Backup recovery
Data backup
Managing logs
Data security
Managing the allowlist (new version)
Configuring SSL encryption
Configuring parameters
Operation and maintenance events
Task center
Extensions
API reference
V2(2022-01-01)
Managing instances
Managing accounts
Managing schemas
Managing connections
Managing parameters
Backup and recovery
Managing logs
Event management
Data security
Task management
SDK reference
Developer tool
Best practices
Performance document
FAQs
Terms
- Documentation
RDS for PostgreSQL API referenceV2(2022-01-01)Managing logsDescribeFailoverLogs
Copy page
Download PDFManaging logs
DescribeFailoverLogs
Copy pageDownload PDFDescribeFailoverLogs
Call the DescribeFailoverLogs API to query the primary/secondary switchover log of the instance.
Request type
Synchronous request.
Debug
API Explorer
You can initiate calls online through API Explorer without paying attention to the signature generation process and quickly obtain the call results.
Request parameters
Parameter | Type | Required? | Example | Description |
Parameter | Type | Required? | Example | Description |
InstanceId | String | Yes | postgres-21a3333b**** | Instance ID. |
QueryStartTime | String | No | 2023-07-31T12:00:19Z | retrieve start time. Format: yyyy-MM-ddTHH:mmZ (UTC time). t refers to the start of a specific time; z refers to the time zone offset, for example, Beijing time offset is +0800. The default value is the instance creation time, meaning the query starts from the instance creation. |
QueryEndTime | String | No | 2023-07-31T12:00:19Z | The query end time must be later than the start time, and the interval between the start and end times should be less than 31 days. Format: yyyy-MM-ddTHH:mmZ (UTC time). The default value is the request initiation time. |
Limit | Integer | No | 1000 | Records per page. The maximum is 1,000, the minimum is 1, and the default value is 500. |
Context | String | No | [1690808035000,100367578,8388608,null] | Index information, used to load more logs on page turn. Pass through the previously returned context value to retrieve subsequent log content. The default value is empty. |
Response parameter
Parameter | Type | Example | Description |
Parameter | Type | Example | Description |
Total | Integer | 1 | Total number of switchover logs. |
InstanceId | String | postgres-21a3333b**** | Instance ID. |
FailoverLogs | Refer to the Sample response. | Switch primary node log list. | |
Context | String | [1690808035000,100367578,8388608,null] | Index information. Use the last backup file as the index for return. Can be used as the parameter for the next request. Select when loading more. |
FailoverLogs
Parameter | Type | Example | Description |
Parameter | Type | Example | Description |
NewMasterNodeId | String | postgres-21a3333b****-0 | New primary node ID. |
OldMasterNodeId | String | postgres-21a3333b****-1 | Old primary node ID. |
FailoverType | String | System | switch type.
|
FailoverTime | String | 2020-06-18T01:40:44Z | Switch time between primary and secondary nodes. |
Example
Sample request
POST /?Action=DescribeFailoverLogs&Version=2022-01-01 HTTP/1.1
Content-Type: application/json
Host: rds-postgresql.cn-beijing.volcengineapi.com
X-Date: 20231002T101010Z
Authorization: HMAC-SHA256 Credential=AKLTN2I0MmFiNzMxNWE5NDgzMzk4MmVjMTVkODlkZTZ****/20211202/cn-beijing/rds_postgresql/request,SignedHeaders=x-date, Signature=71d31fc7bcf990142851c9833c5656391486cda0ae2e0b8ada733b7c6458****
{
"InstanceId": "postgres-21a3333b****",
"QueryStartTime": "2023-07-31T12:00:19Z",
"Limit": 50
}
Sample response
{
"ResponseMetadata": {
"RequestId": "20230801163925C4433796666B3E75888D",
"Action": "DescribeFailoverLogs",
"Version": "2022-01-01",
"Service": "rds_postgresql",
"Region": "cn-beijing"
},
"Result": {
"Context": "[1690808035000,100367578,8388608,null]",
"FailoverLogs": [
{
"FailoverTime": "2023-10-16T12:13:39.000Z",
"FailoverType": "User",
"NewMasterNodeId": "postgres-21a3333b****-gsss-867dddc678-j5zdt",
"OldMasterNodeId": "postgres-21a3333b****-c945c486b-kn294"
},
{
"FailoverTime": "2023-10-16T12:13:39.000Z",
"FailoverType": "User",
"NewMasterNodeId": "postgres-21a3333b****-c945c486b-kn294",
"OldMasterNodeId": "postgres-21a3333b****-gsss-867dddc678-j5zdt"
}
],
"InstanceId": "postgres-21a3333b****",
"Total": 2
}
}
Last updated: 2026.03.31 10:45:18
All rights reserved © Beijing Volcano Engine Technology Co., Ltd2024
