我在恢复数据库文件的时候,恢复总是有4处错误,请问您使用的postgresql是多少版本的,能否将您机子上的数据文件备份一份给我呢,万分感谢!
总是提示如下错误:
警告: 恢复中忽略错误: 4
进程退出并返回 1。
使用的是postgresql 9.2的版本。目前为止还未有其他的朋友不能导入的。你看看是否你的数据库安装不正确或是其他的问题。
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。
请看下wiki中的简要说明
我卸载了9.4的安装9.2的了,但还是报同样的错误,我把异常信息粘贴在下面,请帮忙看下,谢谢!
[Err] 错误: 角色 "ecp" 不存在
COMMENT ON COLUMN sso_person.mobile IS '手机';
COMMENT ON COLUMN sso_person.telephone IS '电话';
COMMENT ON COLUMN sso_person.address IS '地址';
COMMENT ON COLUMN sso_person.weixinid IS '微信号';
COMMENT ON COLUMN sso_person.head_pic IS '头像';
COMMENT ON COLUMN sso_person.department IS '部门';
COMMENT ON COLUMN sso_person.post IS '岗位';
COMMENT ON COLUMN sso_person.saltname IS '称呼';
COMMENT ON COLUMN sso_person.qq IS 'qq';
COMMENT ON COLUMN sso_person.xinzuo IS '星座';
COMMENT ON COLUMN sso_person.blood_type IS '血型';
COMMENT ON COLUMN sso_person."character" IS '性格';
COMMENT ON COLUMN sso_person.company_id IS '企业id';
CREATE TABLE sso_person_data (
id character varying(10) NOT NULL,
data text NOT NULL
);
ALTER TABLE public.sso_person_data OWNER TO postgres;
COMMENT ON TABLE sso_person_data IS '人员属性数据';
COMMENT ON COLUMN sso_person_data.id IS 'id';
COMMENT ON COLUMN sso_person_data.data IS 'd自定义数据';
CREATE TABLE sso_position (
id character varying(10) NOT NULL,
company_id character varying(10) NOT NULL,
parent_id character varying(10),
parentids character varying(50),
department_id character varying(10),
departids character varying(100),
name character varying(20) NOT NULL,
description character varying(200),
permission text,
quota smallint DEFAULT 1,
type integer,
sort_num integer DEFAULT 1,
is_head integer,
m integer
);
ALTER TABLE public.sso_position OWNER TO postgres;
COMMENT ON TABLE sso_position IS '岗位';
COMMENT ON COLUMN sso_position.id IS 'id';
COMMENT ON COLUMN sso_position.company_id IS '企业id';
COMMENT ON COLUMN sso_position.parent_id IS '父级id';
COMMENT ON COLUMN sso_position.parentids IS 'p父级id集合';
COMMENT ON COLUMN sso_position.department_id IS '部门id';
COMMENT ON COLUMN sso_positio
[Err] 错误: 语法错误 在 "1" 或附近的
LINE 527: 1 \N 北京 4 1
^
COMMENT ON COLUMN wf_hist_task.expire_time IS '任务期望完成时间';
COMMENT ON COLUMN wf_hist_task.action_url IS '任务处理url';
COMMENT ON COLUMN wf_hist_task.parent_task_id IS '父任务ID';
COMMENT ON COLUMN wf_hist_task.variable IS '附属变量json存储';
CREATE TABLE wf_hist_task_actor (
task_id character varying(100) NOT NULL,
actor_id character varying(100) NOT NULL
);
ALTER TABLE public.wf_hist_task_actor OWNER TO postgres;
COMMENT ON TABLE wf_hist_task_actor IS '历史任务参与者表';
COMMENT ON COLUMN wf_hist_task_actor.task_id IS '任务ID';
COMMENT ON COLUMN wf_hist_task_actor.actor_id IS '参与者ID';
CREATE TABLE wf_order (
id character varying(100) NOT NULL,
parent_id character varying(100),
process_id character varying(100) NOT NULL,
creator character varying(100),
create_time character varying(50) NOT NULL,
expire_time character varying(50),
last_update_time character varying(50),
last_updator character varying(100),
priority smallint,
parent_node_name character varying(100),
order_no character varying(100),
variable character varying(2000),
version smallint
);
ALTER TABLE public.wf_order OWNER TO postgres;
COMMENT ON TABLE wf_order IS '流程实例表';
COMMENT ON COLUMN wf_order.id IS '主键ID';
COMMENT ON COLUMN wf_order.parent_id IS '父流程ID';
COMMENT ON COLUMN wf_order.process_id IS '流程定义ID';
COMMENT ON COLUMN wf_order.creator IS '发起人';
COMMENT ON COLUMN wf_order.create_time IS '发起时间';
COMMENT ON COLUMN wf_order.expire_time IS '期望完成时间';
COMMENT ON COLUMN wf_order.last_update_time IS '上次更新时间';
COMMENT ON COLUMN wf_order.last_updator IS '上次更新人';
COMMENT ON COLUMN wf_order.priority IS '优先级';
COMMENT ON COLUMN wf_order.parent_node_name IS '父流程依赖的节点名称';
COMMENT ON COLUMN wf_order.order_no IS '流程实例编号';
COMMENT ON COLUMN wf_order.variable IS '附属变量json存储';
COMMENT ON COLUMN wf_order.version IS '版本';
CREATE TABL
[Err] 错误: 语法错误 在 "1001" 或附近的
LINE 2: 1001 0001 1001 库存现金 0 0 1 0
^
[Err] 1001 0001 1001 库存现金 0 0 1 0
1002 0001 1002 银行存款 0 0 1 0
100201 1002 0001 100201 招行科技园支行 0 0 1 0
100202 1002 0001 100202 工行高新支行 0 0 1 0
100203 1002 0001 100203 农行港币户 0 0 1 0
1012 0001 1012 其他货币资金 0 0 1 0
1101 0001 1101 短期投资 0 0 1 0
110101 1101 0001 110101 股票 0 0 1 0
110102 1101 0001 110102 债券 0 0 1 0
110103 1101 0001 110103 基金 0 0 1 0
110110 1101 0001 110110 其他 0 0 1 0
1121 0001 1121 应收票据 0 0 1 0
1122 0001 1122 应收账款 0 0 1 0
1123 0001 1123 预付账款 0 0 1 0
1131 0001 1131 应收股利 0 0 1 0
1132 0001 1132 应收利息 0 0 1 0
1221 0001 1221 其他应收款 0 0 1 0
1401 0001 1401 材料采购 0 0 1 0
1402 0001 1402 在途物资 0 0 1 0
1403 0001 1403 原材料 0 0 1 0
1404 0001 1404 材料成本差异 0 0 1 0
1405 0001 1405 库存商品 0 0 1 0
1407 0001 1407 商品进销差价 0 0 1 0
1408 0001 1408 委托加工物资 0 0 1 0
1411 0001 1411 周转材料 0 0 1 0
1421 0001 1421 消耗性生物资产 0 0 1 0
1501 0001 1501 长期债券投资 0 1 1 0
150101 1501 0001 150101 债券投资 0 1 1 0
150102 1501 0001 150102 其他债权投资 0 1 1 0
1511 0001 1511 长期股权投资 0 1 1 0
151101 1511 0001 151101 股票投资 0 1 1 0
151102 1511 0001 151102 其他股权投资 0 1 1 0
1601 0001 1601 固定资产 0 1 1 0
1602 0001 1602 累计折旧 0 1 1 1
1604 0001 1604 在建工程 0 1 1 0
160401 1604 0001 160401 建筑工程 0 1 1 0
160402 1604 0001 160402 安装工程 0 1 1 0
160403 1604 0001 160403 技术改造工程 0 1 1 0
160404 1604 0001 160404 其他支出 0 1 1 0
1605 0001 1605 工程物资 0 1 1 0
1606 0001 1606 固定资产清理 0 1 1 0
1621 0001 1621 生产性生物资产 0 1 1 0
1622 0001 1622 生产性生物资产累计折旧 0 1 1 1
1701 0001 1701 无形资产 0 1 1 0
1702 0001 1702 累计摊销 0 1 1 1
1801 0001 1801 长期待摊费用 0 1 1 0
1901 0001 1901 待处理财产损溢 0 1 1 0
2001 0001 2001 短期0款 1 2 1 1
2201 0001 2201 应付票据 1 2 1 1
2202 0001 2202 应付账款 1 2 1 1
2203 0001 2203 预收账款 1 2 1 1
2211 0001 2211 应付职工薪酬 1 2 1 1
2221 0001 2221 应交税费 1 2 1 1
222101 2221 0001 222101 应交增值税 1 2 1 1
22210101 222101 0001 22210101 进项税额 1 2 1 0
22210102 222101 0001 22210102 已交税金 1 2 1 0
22210103 222101 0001 22210103 减免税款 1 2 1 0
22210104 222101 0001 22210104 出口抵减内销产品应纳税额 1 2 1 0
22210105 222101 0001 22210105 转出未交增值税 1 2 1 0
22210106 222101 0001 22210106 销项税额 1 2 1 1
22210107 222101 0001 22210107 出口退税 1 2 1 1
22210108 222101 0001 22210108 进项税额转出 1 2 1 1
22210109 222101 0001 22210109 转出多交增值税 1 2 1 1
222102 2221 0001 222102 未交增值税 1 2 1 1
222103 2221 0001 222103 应交营业税 1 2 1 1
222104 2221 0001 222104 应交消费税 1 2 1 1
222105 2221 0001 222105 应交资源税 1 2 1 1
222106 2221 0001 222106 应交所得税 1 2 1 1
222107 2221 0001 222107 应交土地增值税 1 2 1 1
222108 2221 0001 222108 应交城市维护建设税 1 2 1 1
222109 2221 0001 222109 应交房产税 1 2 1 1
222110 2221 0001 222110 应交土地使用税 1 2 1 1
222111 2221 0001 222111 应交车船使用税 1 2 1 1
222112 2221 0001 222112 应交个人所得税 1 2 1 1
222113 2221 0001 222113 教育费附加 1 2 1 1
2231 0001 2231 应付利息 1 2 1 1
2232 0001 2232 应付利润 1 2 1 1
2241 0001 2241 其他应付款 1 2 1 1
2401 0001 2401 递延收益 1 2 1 1
2501 0001 2501 长期0款 1 2 1 1
2701 0001 2701 长期应付款 1 2 1 1
3001 0001 3001 实收资本 2 4 1 1
3002 0001 3002 资本公积 2 4 1 1
300201 3002 0001 300201 资本溢价 2 4 1 1
300202 3002 0001 300202 接受捐赠非现金资产准备 2 4 1 1
300206 3002 0001 300206 外币资本折算差额 2 4 1 1
300207 3002 0001 300207 其他资本公积 2 4 1 1
3101 0001 3101 盈余公积 2 4 1 1
310101 3101 0001 310101 法定盈余公积 2 4 1 1
310102 3101 0001 310102 任意盈余公积 2 4 1 1
310103 3101 0001 310103 法定公益金 2 4 1 1
3103 0001 3103 本年利润 2 4 1 1
3104 0001 3104 利润分配 2 4 1 1
310401 3104 0001 310401 其他转入 2 4 1 0
310402 3104 0001 310402 提取法定盈余公积 2 4 1 0
310403 3104 0001 310403 提取法定公益金 2 4 1 0
310409 3104 0001 310409 提取任意盈余公积 2 4 1 0
310410 3104 0001 310410 应付利润 2 4 1 0
310411 3104 0001 310411 转作资本的利润 2 4 1 0
310415 3104 0001 310415 未分配利润 2 4 1 1
4001 0001 4001 生产成本 3 5 1 0
400101 4001 0001 400101 基本生产成本 3 5 1 0
400102 4001 0001 400102 辅助生产成本 3 5 1 0
4101 0001 4101 制造费用 3 5 1 0
4301 0001 4301 研发支出 3 5 1 0
4401 0001 4401 工程施工 3 5 1 0
4403 0001 4403 机械作业 3 5 1 0
5001 0001 5001 主营业务收入 4 6 1 1
5051 0001 5051 其他业务收入 4 7 1 1
5111 0001 5111 投资收益 4 7 1 1
5301 0001 5301 营业外收入 4 7 1 1
530101 5301 0001 530101 非流动资产处置净收益 4 7 1 1
530102 5301 0001 530102 政府补助 4 7 1 1
530103 5301 0001 530103 捐赠收益 4 7 1 1
530104 5301 0001 530104 盘盈收益 4 7 1 1
530105 5301 0001 530105 其他 4 7 1 1
5401 0001 5401 主营业务成本 4 11 1 0
5402 0001 5402 其他业务成本 4 10 1 0
5403 0001 5403 营
[Err] 错误: 关系 "sso_person_data" 不存在
ALTER TABLE ONLY oa_file
ADD CONSTRAINT oa_file_pkey PRIMARY KEY (id);
ALTER TABLE ONLY oa_knowledge
ADD CONSTRAINT oa_knowledge_pkey PRIMARY KEY (id);
ALTER TABLE ONLY oa_message
ADD CONSTRAINT oa_message_pkey PRIMARY KEY (id);
ALTER TABLE ONLY oa_notice
ADD CONSTRAINT oa_notice_pkey PRIMARY KEY (id);
ALTER TABLE ONLY oa_task
ADD CONSTRAINT oa_task_pkey PRIMARY KEY (id);
ALTER TABLE ONLY oa_topic_rep
ADD CONSTRAINT oa_topic_rep_pkey PRIMARY KEY (id);
ALTER TABLE ONLY oa_workreport
ADD CONSTRAINT oa_workreport_pkey PRIMARY KEY (id);
ALTER TABLE ONLY oa_workreporttemp
ADD CONSTRAINT oa_workreporttemp_name_key UNIQUE (name);
ALTER TABLE ONLY oa_workreporttemp
ADD CONSTRAINT oa_workreporttemp_pkey PRIMARY KEY (id);
ALTER TABLE ONLY os_topic
ADD CONSTRAINT os_topic_pkey PRIMARY KEY (id);
ALTER TABLE ONLY scm_competitor
ADD CONSTRAINT scm_competitor_pkey PRIMARY KEY (id);
ALTER TABLE ONLY scm_depot
ADD CONSTRAINT scm_depot_pkey PRIMARY KEY (id);
ALTER TABLE ONLY scm_order_data
ADD CONSTRAINT scm_order_data_id_key UNIQUE (id);
ALTER TABLE ONLY scm_order
ADD CONSTRAINT scm_order_pkey PRIMARY KEY (id);
ALTER TABLE ONLY scm_product
ADD CONSTRAINT scm_product_pkey PRIMARY KEY (id);
ALTER TABLE ONLY scm_product_price_order
ADD CONSTRAINT scm_product_price_order_pkey PRIMARY KEY (id);
ALTER TABLE ONLY scm_stock_allot
ADD CONSTRAINT scm_stock_allot_pkey PRIMARY KEY (id);
ALTER TABLE ONLY scm_stock_check
ADD CONSTRAINT scm_stock_check_pkey PRIMARY KEY (id);
ALTER TABLE ONLY scm_storage_bill
ADD CONSTRAINT scm_storage_bill_pkey PRIMARY KEY (id);
ALTER TABLE ONLY sso_action_log
ADD CONSTRAINT sso_action_log_pkey PRIMARY KEY (id);
ALTER TABLE ONLY sso_company
ADD CONSTRAINT sso_company_code_key UNIQUE (code);
ALTER TABLE ONLY sso_company
ADD CON
[Err] 错误: 关系 "wf_hist_task_actor" 不存在
ALTER TABLE ONLY wf_hist_task_actor
ADD CONSTRAINT fk_hist_taskactor FOREIGN KEY (task_id) REFERENCES wf_hist_task(id);
ALTER TABLE ONLY wf_order
ADD CONSTRAINT fk_order_parentid FOREIGN KEY (parent_id) REFERENCES wf_order(id);
ALTER TABLE ONLY wf_order
ADD CONSTRAINT fk_order_processid FOREIGN KEY (process_id) REFERENCES wf_process(id);
ALTER TABLE ONLY wf_task_actor
ADD CONSTRAINT fk_task_actor_taskid FOREIGN KEY (task_id) REFERENCES wf_task(id);
ALTER TABLE ONLY wf_task
ADD CONSTRAINT fk_task_orderid FOREIGN KEY (order_id) REFERENCES wf_order(id);
ALTER TABLE ONLY hr_assessment_kpi
ADD CONSTRAINT hr_assessment_kpi_model_id_fkey FOREIGN KEY (model_id) REFERENCES hr_assessment_model(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE ONLY hr_assessment_model
ADD CONSTRAINT hr_assessment_model_postion_id_fkey FOREIGN KEY (postion_id) REFERENCES sso_position(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE ONLY hr_pact
ADD CONSTRAINT hr_pact_employee_id_fkey FOREIGN KEY (employee_id) REFERENCES hr_employee(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE ONLY hr_salary
ADD CONSTRAINT hr_salary_employee_id_fkey FOREIGN KEY (employee_id) REFERENCES hr_employee(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE ONLY oa_comment
ADD CONSTRAINT oa_comment_creator_role_id_fkey FOREIGN KEY (creator_role_id) REFERENCES sso_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE ONLY oa_dream_board
ADD CONSTRAINT oa_dream_board_company_id_fkey FOREIGN KEY (company_id) REFERENCES sso_company(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE ONLY oa_dream_board
ADD CONSTRAINT oa_dream_board_user_id_fkey FOREIGN KEY (user_id) REFERENCES sso_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE ONLY oa_file
ADD CONSTRAINT oa_file_creater_id_fkey FOREIGN KEY (creater_id) REFERENCES sso_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE ONLY oa_knowledge
ADD CONSTRAINT oa_knowledge_category_id_fkey FOREIGN KEY (category_id) REFERENCES sso_parame(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE ONLY oa_knowledge
ADD CONSTRAINT oa_knowledge_user_id_fkey FOREIGN KEY (user_id) REFERENCES sso_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE ONLY oa_message
ADD CONSTRAINT oa_message_from_user_id_fkey FOREIGN KEY (from_user_id) REFERENCES sso_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
搜索下 ecp, 然后 改成 你 数据库里 对应的 名称 就可以了
已经搞定了 谢谢
状态更改为 已关闭
登录 后才可以发表评论