UserX具有以下授予:
CREATE ROLE "UserX" LOGIN PASSWORD 'pass';
CREATE DATABASE "DBX" WITH OWNER="UserX" ENCODING='UTF8' TABLESPACE=pg_default CONNECTION LIMIT=-1;
GRANT CONNECT ON DATABASE "DBX" TO "UserX";
GRANT USAGE ON SCHEMA public TO "UserX";
GRANT SELECT,INSERT,UPDATE,DELETE ON ALL TABLES IN SCHEMA public TO "UserX";
ALTER DEFAULT PRIVILEGES GRANT ALL ON TABLES TO "UserX";
ALTER DEFAULT PRIVILEGES GRANT ALL ON SEQUENCES TO "UserX";
尝试将其转储还原到其他数据库时出现以下错误:
pg_restore: creating SEQUENCE "public.tblX_Id_seq"
pg_restore: [archiver (db)] Error from TOC entry 218; 1259 438745 SEQUENCE tblX_Id_seq UserX
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "AS"
LINE 2: AS integer
^
Command was: CREATE SEQUENCE "tblX_Id_seq"
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACH...
pg_restore: [archiver (db)] could not execute query: ERROR: relation "tblX_Id_seq" does not exist
Command was: ALTER TABLE "tblX_Id_seq" OWNER TO "UserX";
pg_restore: creating SEQUENCE OWNED BY "public.tblX_Id_seq"
pg_restore: [archiver (db)] Error from TOC entry 3569; 0 0 SEQUENCE OWNED BY tblX_Id_seq UserX
pg_restore: [archiver (db)] could not execute query: ERROR: relation "tblX_Id_seq" does not exist
Command was: ALTER SEQUENCE "tblX_Id_seq" OWNED BY "tblX"."Id";
...
pg_restore: creating DEFAULT "public.tblX Id"
pg_restore: [archiver (db)] Error from TOC entry 2995; 2604 438750 DEFAULT tblX Id UserX
pg_restore: [archiver (db)] could not execute query: ERROR: relation "tblX_Id_seq" does not exist
Command was: ALTER TABLE ONLY "tblX" ALTER COLUMN "Id" SET DEFAULT nextval('"tblX_Id_seq"'::regclass);
...
pg_restore: executing SEQUENCE SET tblX_Id_seq
pg_restore: [archiver (db)] Error from TOC entry 3607; 0 0 SEQUENCE SET tblX_Id_seq UserX
pg_restore: [archiver (db)] could not execute query: ERROR: relation "tblX_Id_seq" does not exist
LINE 1: SELECT pg_catalog.setval('"tblX_Id_seq"', 1573, true);
^
Command was: SELECT pg_catalog.setval('"tblX_Id_seq"', 1573, true);
关于我做错了什么建议吗?
您正在尝试将转储从v10数据库还原到旧版本的PostgreSQL(CREATE SEQUENCE ... AS
v10中的新增功能)。
那不被支持,将不起作用。您可以使用创建SQL脚本pg_restore
并进行手动编辑。或升级目标数据库。
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句