转储 postgresql 数据库源一具有编码'C.UTF-8'目标一具有编码'en_US.UTF-8'

Question

尝试将编码为"C.UTF-8"的源数据库转储到编码为"en_US.UTF-8"的目标数据库，如下所示：

pg_dump -C --no-acl --no-owner -h HOST_SOURCE -U Admin -p 5432 SOURCE_DB | psql -h HOST_DESTINATION -U Admin -p 5432 DESTINATION_DB

我得到以下错误：

ERROR:  invalid locale name: "C.UTF-8"
connect: FATAL:  database "SOURCE_DB" does not exist

如何忽略pg_dump命令上的编码？

Answer 1

取决于评论@LaurenzAlbe，当我删除-C选项时，命令运行良好！

pg_dump --no-acl --no-owner -h HOST_SOURCE -U Admin -p 5432 SOURCE_DB | psql -h HOST_DESTINATION -U Admin -p 5432 DESTINATION_DB