我有同样的问题，我创建了一个新的数据库，并得到无效的命令\N恢复与psql。 我通过设置与旧数据库相同的表空间来解决这个问题。

例如，旧数据库备份有表空间“pg_default”，我给新数据库定义了相同的表空间，上面的错误已经消失了!

大多数时候，解决方案是安装postgres-contrib包。

检查表中的列和备份文件中的列是否合适

安装postgresql-(你的版本)-postgis-scripts

Adding my resolution, incase it helps anyone. I installed postgis but the error wasn't resolved. The --inserts option was not feasible as I had to copy a big schema having tables with thousands of rows. For the same database I didn't see this issue when pg_dump and psql (restore) were run on mac. But the issue came when pg_dump was run on linux machine, the dump file copied to mac and tried for restore. So I opened the dump file in VSCode. It detected unusual line terminators and gave option to remove them. After doing that the dump file restore ran without the invalid command \N errors.

我有同样的问题，我创建了一个新的数据库，并得到无效的命令\N恢复与psql。 我通过设置与旧数据库相同的表空间来解决这个问题。

例如，旧数据库备份有表空间“pg_default”，我给新数据库定义了相同的表空间，上面的错误已经消失了!