Abnormal Issues from PG to PG

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: pg到pg问题异常

| username: dbaspace

Using Debezium for online data synchronization from PostgreSQL to PostgreSQL, the architecture is as follows:

image
image1362×424 45.2 KB

Currently encountering an issue where tables with array data types cannot be synchronized. Table structure:
image
image1124×294 25.6 KB

Synchronization error:

image
image1380×692 331 KB

Does anyone know how to handle this?

2
| username: Billmay表妹 | Original post link

How about considering migrating to TiDB?

3
| username: Billmay表妹 | Original post link
4
| username: dbaspace | Original post link

Overseas business, the current volume is relatively small, so we are using PostgreSQL for report analysis :laughing:

5
| username: 有猫万事足 | Original post link

Let’s go with TiDB Serverless, I remember the storage is free if it’s under 5GB.

6
| username: xfworld | Original post link

It is estimated that Debezium cannot support such a capricious type for the time being. Check if the higher version supports it.

7
| username: Billmay表妹 | Original post link

5 clusters with 5GB usage each, approximately 25GB of free quota.

8
| username: TiDBer_CkS2lbTx | Original post link

It’s okay with a small amount of data, but transferring large amounts of data with Navicat is simply a nightmare.

9
| username: 这里介绍不了我 | Original post link

The TiDB community is asking for PostgreSQL talent.

10
| username: dbaspace | Original post link

I also popularized that Debezium can be used as a good tool for data synchronization.

11
| username: DBAER | Original post link

I think we need to ask the software community.

12
| username: Billmay表妹 | Original post link

Which cloud are you on?

13
| username: 这里介绍不了我 | Original post link

This is indeed quite good :joy:

14
| username: 洪七表哥 | Original post link

Hurry up and learn Debezium.