Rjg9R2tK

1
2pg_restore: [архиватор (БД)] Ошибка при обработке оглавления:
3pg_restore: [архиватор (БД)] Ошибка из записи оглавления 7063; 2606 200515 CONSTRAINT employee employee_pkey userside
4pg_restore: [архиватор (БД)] could not execute query: ERROR:  cannot drop constraint employee_pkey on table public.employee because other objects depend on it
5ПОДРОБНОСТИ:  constraint fk-position_held-employee on table public.position_held depends on index public.employee_pkey
6constraint fk-position_held_employed-employee on table public.position_held depends on index public.employee_pkey
7constraint fk-position_held_dismissed-employee on table public.position_held depends on index public.employee_pkey
8constraint fk-pbl_employee_ext_employee_id-employee_id on table userside3.pbl_employee_ext depends on index public.employee_pkey
9ПОДСКАЗКА:  Use DROP ... CASCADE to drop the dependent objects too.
10    Выполнялась команда: ALTER TABLE IF EXISTS ONLY public.employee DROP CONSTRAINT IF EXISTS employee_pkey;
11
12pg_restore: [архиватор (БД)] Ошибка из записи оглавления 227; 1259 197965 TABLE employee userside
13pg_restore: [архиватор (БД)] could not execute query: ERROR:  cannot drop table public.employee because other objects depend on it
14ПОДРОБНОСТИ:  constraint fk-position_held-employee on table public.position_held depends on table public.employee
15constraint fk-position_held_employed-employee on table public.position_held depends on table public.employee
16constraint fk-position_held_dismissed-employee on table public.position_held depends on table public.employee
17constraint fk-pbl_employee_ext_employee_id-employee_id on table userside3.pbl_employee_ext depends on table public.employee
18ПОДСКАЗКА:  Use DROP ... CASCADE to drop the dependent objects too.
19    Выполнялась команда: DROP TABLE IF EXISTS public.employee;
20
21pg_restore: [архиватор (БД)] Ошибка из записи оглавления 2; 3079 196407 EXTENSION postgis
22pg_restore: [архиватор (БД)] could not execute query: ERROR:  cannot drop extension postgis because other objects depend on it
23ПОДРОБНОСТИ:  table userside3.pbl_address_unit_ext column coord depends on type public.geometry
24table userside3.pbl_address_building column coord depends on type public.geometry
25ПОДСКАЗКА:  Use DROP ... CASCADE to drop the dependent objects too.
26    Выполнялась команда: DROP EXTENSION IF EXISTS postgis;
27
28pg_restore: [архиватор (БД)] Ошибка из записи оглавления 1; 3079 13384 EXTENSION plpgsql
29pg_restore: [архиватор (БД)] could not execute query: ERROR:  cannot drop extension plpgsql because other objects depend on it
30ПОДРОБНОСТИ:  extension postgis depends on language plpgsql
31table userside3.pbl_address_unit_ext column coord depends on type public.geometry
32table userside3.pbl_address_building column coord depends on type public.geometry
33ПОДСКАЗКА:  Use DROP ... CASCADE to drop the dependent objects too.
34    Выполнялась команда: DROP EXTENSION IF EXISTS plpgsql;
35
36pg_restore: [архиватор (БД)] Ошибка из записи оглавления 9; 2615 196406 SCHEMA userside3 userside
37pg_restore: [архиватор (БД)] could not execute query: ERROR:  cannot drop schema userside3 because other objects depend on it
38ПОДРОБНОСТИ:  table userside3.pbl_address_building_address depends on schema userside3
39table userside3.pbl_address_building_map depends on schema userside3
40table userside3.pbl_advert_address depends on schema userside3
41table userside3.pbl_cable_line_type depends on schema userside3
42table userside3.pbl_cable_line_type_operator_profile_access depends on schema userside3
43table userside3.pbl_links_operator_profile depends on schema userside3
44table userside3.pbl_device_iferr_current depends on schema userside3
45table userside3.pbl_device_iferr_history depends on schema userside3
46table userside3.pbl_conf_layer_object depends on schema userside3
47table userside3.pbl_pon_onu_data depends on schema userside3
48table userside3.pbl_task_repeat_option depends on schema userside3
49table userside3.pbl_task_type_sequence depends on schema userside3
50table userside3.pbl_control_device_custom_oid depends on schema userside3
51table userside3.pbl_control_device_receiver_division depends on schema userside3
52table userside3.pbl_control_device_receiver_employee depends on schema userside3
53table userside3.pbl_conf_task_watcher depends on schema userside3
54table userside3.pbl_node_map depends on schema userside3
55table userside3.pbl_operator_address_access depends on schema userside3
56table userside3.pbl_radio_equip_data depends on schema userside3
57table userside3.pbl_mark_object depends on schema userside3
58table userside3.pbl_staff_work_address_access depends on schema userside3
59table userside3.pbl_task_type_division_work_address depends on schema userside3
60table userside3.pbl_task_type_staff_work_address depends on schema userside3
61table userside3.pbl_employee_ext depends on schema userside3
62table userside3.pbl_address_unit_ext depends on schema userside3
63table userside3.pbl_address_alias_type depends on schema userside3
64table userside3.pbl_address_building depends on schema userside3
65ПОДСКАЗКА:  Use DROP ... CASCADE to drop the dependent objects too.
66    Выполнялась команда: DROP SCHEMA IF EXISTS userside3;
67
68pg_restore: [архиватор (БД)] Ошибка из записи оглавления 7; 2615 2200 SCHEMA public postgres
69pg_restore: [архиватор (БД)] could not execute query: ERROR:  cannot drop schema public because other objects depend on it
70ПОДРОБНОСТИ:  table public.employee depends on schema public
71constraint fk-pbl_employee_ext_employee_id-employee_id on table userside3.pbl_employee_ext depends on table public.employee
72table public.department depends on schema public
73table public.position_held depends on schema public
74table public.attachments depends on schema public
75extension postgis depends on schema public
76table userside3.pbl_address_unit_ext column coord depends on type public.geometry
77table userside3.pbl_address_building column coord depends on type public.geometry
78table public.auth_rule depends on schema public
79table public.auth_item depends on schema public
80table public.auth_item_child depends on schema public
81table public.auth_assignment depends on schema public
82table public.auth_ldap_group depends on schema public
83ПОДСКАЗКА:  Use DROP ... CASCADE to drop the dependent objects too.
84    Выполнялась команда: DROP SCHEMA IF EXISTS public;
85
86pg_restore: [архиватор (БД)] could not execute query: ERROR:  schema "public" already exists
87    Выполнялась команда: CREATE SCHEMA public;
88
89
90
91pg_restore: [архиватор (БД)] Ошибка из записи оглавления 9; 2615 196406 SCHEMA userside3 userside
92pg_restore: [архиватор (БД)] could not execute query: ERROR:  schema "userside3" already exists
93    Выполнялась команда: CREATE SCHEMA userside3;
94
95
96
97pg_restore: [архиватор (БД)] Ошибка из записи оглавления 227; 1259 197965 TABLE employee userside
98pg_restore: [архиватор (БД)] could not execute query: ERROR:  relation "employee" already exists
99    Выполнялась команда: CREATE TABLE public.employee (
100    id integer NOT NULL,
101    firstname character varying(255),
102    lastname character varying(255),
103    middlename character varying(255),
104    title character varying(255),
105    birthday integer,
106    photo character varying(255),
107    language_id integer,
108    last_activity_at integer
109);
110
111
112
113pg_restore: [архиватор (БД)] Ошибка из записи оглавления 8117; 0 197965 TABLE DATA employee userside
114pg_restore: [архиватор (БД)] could not execute query: ERROR:  column "language_id" of relation "employee" does not exist
115    Выполнялась команда: COPY public.employee (id, firstname, lastname, middlename, title, birthday, photo, language_id, last_activity_at) FROM stdin;
116
117pg_restore: [архиватор (БД)] Ошибка из записи оглавления 7063; 2606 200515 CONSTRAINT employee employee_pkey userside
118pg_restore: [архиватор (БД)] could not execute query: ERROR:  multiple primary keys for table "employee" are not allowed
119    Выполнялась команда: ALTER TABLE ONLY public.employee
120    ADD CONSTRAINT employee_pkey PRIMARY KEY (id);
121
122
123
124pg_restore: [архиватор (БД)] Ошибка из записи оглавления 7963; 2606 201473 FK CONSTRAINT employee fk-employee-conf_languages userside
125pg_restore: [архиватор (БД)] could not execute query: ERROR:  column "language_id" referenced in foreign key constraint does not exist
126    Выполнялась команда: ALTER TABLE ONLY public.employee
127    ADD CONSTRAINT "fk-employee-conf_languages" FOREIGN KEY (language_id) REFERENCES public.conf_languages(id) ON UPDATE CASCADE ON DELETE RESTRICT;
128
129
130
131ПРЕДУПРЕЖДЕНИЕ: при восстановлении проигнорировано ошибок: 12