tencent cloud

Log In Sign Up Free

Detect AI Fraud with Tencent eKYC！Intercept 99%+ Deepfake Attacks!

TencentDB for PostgreSQL

Release Notes and Announcements

Announcements

TencentDB for PostgreSQL's Full Support for PG17

Notice on Discontinuing the Sale of TencentDB for PostgreSQL 10 Soon

Notice on Decommissioning the Serverless Instance Creation API for TencentDB for PostgreSQL

Security Risk Statement for Creating Partial Plugins in PostgreSQL Cloud Database

TencentDB for PostgreSQL Will Start Billing for Backup Space

Some Extensions on Lower Kernel Version Can't Be Created and Upgraded in TencentDB for PostgreSQL

Announcement on the Risk of Privilege Escalation Vulnerability in Cloud Database PostgreSQL Open Source Plugin

Product Introduction

Product Overview

Information Security

Regions and AZs

Large version lifecycle description

Purchase Guide

Billing Overview

Instance Type and Specification

Purchase Methods

Instance Upgrade

Payment Overdue

Backup Space Billing

Getting Started

Creating TencentDB for PostgreSQL Instance

Connecting to TencentDB for PostgreSQL Instance

Managing TencentDB for PostgreSQL Instance

Migrating Data with DTS

Kernel Version Introduction

Kernel Version Overview

Kernel Version Release Notes

Viewing Kernel Version

Proprietary Kernel Features

Logical Replication Slot Failover

Making Buffer Invalid Asynchronously

Process Monitoring

SQL Traffic Throttling

Read-Write Separation with starocks_fdw

Operation Guide

Instance Management

Instance Lifecycle

Setting Instance Maintenance Time

Modifying Instance Configuration

Setting instance availability zone for disaster recovery or region disaster recovery

Terminating Instances

Restoring Instances

Eliminating Instances

Restarting Instances

Modifying Data Replication Mode

Switch Source-Replica Instance

Upgrading Instance

Instructions for Upgrading Kernel Minor Version

Kernel Minor Version Upgrade

Upgrade the Major Version of the Database

Read-Only Instance

Managing RO Groups

Removal Policy and Load Balancing

Account Management

Database Privilege Overview

Users and Permission Operations

Console Operation Instructions

Database Management

Database Management via Console

Database Optimization

Slow Log Analysis

Parameter Management

Setting Instance Parameters

Parameter Value Limits

Parameter Template

Setting soft_limit_connections Parameters

Log Management and Analysis

Execution Log Management

Backup and Restoration

Backup Principles and Solutions

Backing up Data

Downloading Backup

Cloning Instance

Automatic Backup Settings

Restoring PostgreSQL Data on CVMs

Deleting Backup

Viewing Backup Space

Setting Backup Download Rules

Use Serverless Cloud Function to Transfer Historical Backups of PostgreSQL

Rollback to the Original Instance

Data Migration

DTS-Based Logical Migration

Operation Guide

Verification Failure Handling

Database Connection Check

Dependency Check

Incremental Migration Check

Structure Compatibility Check

Structure Conflict Check

Account Conflict Check

Parameter Configuration Conflict Check

Plugin Compatibility Check

Multi-Task Conflict Check

Long Transaction Check

Creating a Data Consistency Check Task

Physical migration based on DTS

Configure Physical Migration Tasks

Physical Migration Check Items

Database Audit

Audit Service Description

Activating Audit Service

View Audit Logs

Modify audit services

Audit Performance Description

Extension Management

Extension Overview

Supported Extensions

TencentDB for PostgreSQL 9.3

TencentDB for PostgreSQL 9.5

pgAgent Extension

postgres_fdw Extension for Cross-database Access

pg_roaringbitmap Extension for Bitwise Operation

pg_cron Extension for Job Scheduling

Network Management

Modifying Network

Enabling Public Network Address

Access Management

Access Policy Syntax

Authorizable Resource Types

Console Examples

Data Security

SSL Encryption Settings

Tenant and Resource Isolation

Database Resource Isolation

Security Groups

Managing Security Groups

Associating Instances with Security Groups

Monitoring and Alarms

Monitoring Feature

Alarming Feature

Tag

MSSQL Compatible Version

Architecture Introduction

Function Description

Practical Tutorial

postgres_fdw Extension for Cross-database Access

Automatically Creating Partition in PostgreSQL

Searching in High Numbers of Tags Based on pg_roaringbitmap

Querying People Nearby with One SQL Statement

Configuring TencentDB for PostgreSQL as GitLab's External Data Source

Supporting Tiered Storage Based on cos_fdw Extension

Implement Read/Write Separation via pgpool

Analyzing Slow SQL Using the auto_explain Plugin

Using pglogical for Logical Replication

Performance White Paper

API Documentation

Making API Requests

Request Structure

Instance APIs

Read-only Replica APIs

CreateReadOnlyGroup

DescribeReadOnlyGroups

ModifyReadOnlyGroupConfig

DeleteReadOnlyGroup

CreateReadOnlyDBInstance

AddDBInstanceToReadOnlyGroup

RemoveDBInstanceFromReadOnlyGroup

ModifyDBInstanceReadOnlyGroup

RebalanceReadOnlyGroup

Backup and Recovery APIs

DescribeAvailableRecoveryTime

DescribeCloneDBInstanceSpec

CloneDBInstance

RestoreDBInstanceObjects

DescribeBackupOverview

DescribeBackupSummaries

DescribeBackupPlans

ModifyBackupPlan

CreateBaseBackup

DescribeBaseBackups

ModifyBaseBackupExpireTime

DeleteBaseBackup

DescribeLogBackups

DeleteLogBackup

DescribeBackupDownloadURL

DescribeBackupDownloadRestriction

ModifyBackupDownloadRestriction

DescribeDBXlogs

DescribeDBBackups

Parameter Management APIs

CreateParameterTemplate

DescribeParameterTemplates

DescribeParameterTemplateAttributes

ModifyParameterTemplate

DeleteParameterTemplate

DescribeDefaultParameters

DescribeDBInstanceParameters

DescribeParamsEvent

ModifyDBInstanceParameters

Security Group APIs

DescribeDBInstanceSecurityGroups

ModifyDBInstanceSecurityGroups

Performance Optimization APIs

DescribeDBErrlogs

DescribeSlowQueryAnalysis

DescribeSlowQueryList

DescribeDBSlowlogs

Account APIs

DescribeDatabases

DescribeAccounts

ModifyAccountRemark

ResetAccountPassword

Specification APIs

DescribeRegions

DescribeClasses

DescribeDBVersions

InquiryPriceCreateDBInstances

InquiryPriceRenewDBInstance

InquiryPriceUpgradeDBInstance

DescribeProductConfig

PostgreSQL for Serverless APIs

CreateServerlessDBInstance

DescribeServerlessDBInstances

DeleteServerlessDBInstance

OpenServerlessDBExtranetAccess

CloseServerlessDBExtranetAccess

Network APIs

CreateDBInstanceNetworkAccess

DeleteDBInstanceNetworkAccess

OpenDBExtranetAccess

CloseDBExtranetAccess

CreateReadOnlyGroupNetworkAccess

DeleteReadOnlyGroupNetworkAccess

Service Agreement

Service Level Agreement

Terms of Service

DocumentationTencentDB for PostgreSQLOperation GuideData MigrationDTS-Based Logical MigrationVerification Failure HandlingLong Transaction Check

Long Transaction Check

Last updated: 2024-11-04 10:41:06

Long Transaction Check

Last updated: 2024-11-04 10:41:06

Check Details
If there are long-running transactions in the source database, the verification task will report a warning. You can ignore the warning and continue the task, but it is recommended to handle the long transactions first before starting a Data Transfer Service (DTS) task.
Fixing Method
Process the long transactions in the source database, and then start the DTS task after the transactions have ended.

Was this page helpful?

You can also Contact Sales or Submit a Ticket for help.

Yes

No

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

7x24 Phone Support

Hong Kong, China

+852 800 906 020 (Toll Free)

United States

+1 844 606 0804 (Toll Free)

United Kingdom

+44 808 196 4551 (Toll Free)

Canada

+1 888 605 7930 (Toll Free)

Australia

+61 1300 986 386 (Toll Free)

EdgeOne hotline

+852 300 80699

More local hotlines coming soon