如何修复“八位字节序列#(130)不能被解码”。在pgloader中

SHOW VARIABLES LIKE 'character_set%';
SHOW VARIABLES LIKE 'collation%';

SELECT pg_encoding_to_char(encoding) FROM pg_database WHERE datname = 'your_database_name';

LOAD DATABASE
     FROM mysql://user:password@host/dbname
     INTO postgresql://user:password@host/dbname

 WITH
     encoding = 'utf8'  -- 指定目标数据库的字符编码
     -- 其他选项

 CAST
     type datetime to timestamptz drop default drop not null using zero-dates-to-null,
     type date drop not null drop default using zero-dates-to-null

 SET work_mem to '16MB', maintenance_work_mem to '512 MB';

UPDATE your_table
SET your_column = REPLACE(CONVERT(your_column USING utf8), '�', '');

pgloader --debug your_load_script.load

LOAD DATABASE
     FROM mysql://user:password@host/dbname
     INTO postgresql://user:password@host/dbname

 WITH
     data only
     encoding = 'utf8'  -- 指定目标数据库的字符编码
     -- 其他选项

 CAST
     type datetime to timestamptz drop default drop not null using zero-dates-to-null,
     type date drop not null drop default using zero-dates-to-null

 SET work_mem to '16MB', maintenance_work_mem to '512 MB';

LOAD DATABASE
     FROM mysql://user:password@host/dbname
     INTO postgresql://user:password@host/dbname

 WITH
     batch size = 1000
     encoding = 'utf8'  -- 指定目标数据库的字符编码
     -- 其他选项

 CAST
     type datetime to timestamptz drop default drop not null using zero-dates-to-null,
     type date drop not null drop default using zero-dates-to-null

 SET work_mem to '16MB', maintenance_work_mem to '512 MB';