pg_restore无法执行查询:错误:无效的语言环境名称:"en_US.UTF-8" [英] pg_restore could not execute query: ERROR: invalid locale name: "en_US.UTF-8"

问题描述

我在Windows 10上将pg_restore与在Linux上创建的转储文件一起使用.

I use pg_restore on Windows 10 with a dump file made on Linux.

我在网上搜索，但找不到答案.

I search on the web but I don't find answer.

[NEW]: 我在计算机上安装了Ubuntu以使用pg_restore，但是在发送时

[NEW] : I install Ubuntu on my computer to use pg_restore but when I send

pg_restore -d mydatabase /home/user/Documents/dumpfile.dump

命令行被阻止.

有人遇到了这个问题吗?

Someone has this issue ?

推荐答案

您将需要对语言环境进行一些研究.开始的地方是文档.

You will need to do some research on locales. The place to start is the documentation.

Postgres依赖操作系统获取语言环境信息.在Posix和Windows之间，名称有所不同.据推测，最简单的解决方案是以某种方式更改名称.可能有一种让Windows理解Posix名称的方法.

Postgres relies on the operating system for locale information. The names differ between Posix and Windows. Presumably, the simplest solution is to change the name somehow. There might be a way to get Windows to understand the Posix names.

这篇关于pg_restore无法执行查询:错误:无效的语言环境名称:"en_US.UTF-8"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！