Postgresql

PostgreSQL vs MySQL

https://www.cnblogs.com/geekmao/p/8541817.html

数据迁移 —— 从 PostgreSQL 到 MySQL

https://www.cnblogs.com/xjnotxj/p/12776575.html

数据同步rds pg到rds mysql

https://help.aliyun.com/document_detail/281100.html?spm=a2c4g.11186623.6.1092.2a7f3a02LwkFiJ

只支持pg11 

PG2MySQL

https://github.com/pivotal-cf/pg2mysql

In PostgreSQL it is common to use the text datatype for character data, which the PostgreSQL documentation describes as having effectively no limit. In MySQL this is not the case, as the datatype with the same name (text) is limited to 65535, and the more common datatype, varchar, is defined with an explicit limit (e.g. varchar(255)).

This means that, given a column with text datatype in PostgreSQL, there must be enough room in the equivalent MySQL column for the data in PostgreSQL to be safely migrated over. This tool can be used to validate the target MySQL schema against a populated PostgreSQL database and, provided the data in the PostgreSQL database is compatible, the migration to move the data from PostgreSQL to MySQL.

创建唯一索引

create unique index idx_code_level on test_rule (code, (params->'level'));

连接池pgbouncer

https://devcenter.heroku.com/articles/best-practices-pgbouncer-configuration

https://github.com/pgbouncer/pgbouncer

pgbouncer features

transaction pooling不支持listen和notify

https://www.pgbouncer.org/features.html