sql - 导入没有角色的postgres数据库

Question

我有一个用 pg_dump 导出的数据库，但现在当我试图用以下命令再次导入它时:

psql -d databasename < mydump.sql

尝试将角色授予不存在的人时失败。 (错误提示“角色“xxx”不存在”)

有没有办法为我的用户自动导入和设置所有角色？

Answer 1

导入的默认行为是用您正在导入的角色替换它不知道的所有角色。因此，根据您需要数据库的用途，您可能只需导入它并忽略错误消息即可。

引自http://www.postgresql.org/docs/9.2/static/backup-dump.html#BACKUP-DUMP-RESTORE

Before restoring an SQL dump, all the users who own objects or were granted permissions on objects in the dumped database must already exist. If they do not, the restore will fail to recreate the objects with the original ownership and/or permissions. (Sometimes this is what you want, but usually it is not.)