не получается восстановить бд 1с
после логина в базу - ошибка: Тип не определен '12b36cb8-d8ca-469a-b0e2-06fe2f26e97e'
подскажите как пофиксить?
создаю базу create database test_upp_2020_10;
восстанавливаю данные
/opt/pgpro/1c-12/bin/pg_restore -h 127.0.0.1 -p 5441 -Upostgres --clean --dbname test_upp_2020_10 -w --format=custom upp-2020-10-28_21.backup
потом конфигурацию
/opt/pgpro/1c-12/bin/psql -h 127.0.0.1 -p 5441 -Upostgres -d test_upp_2020_10 -c "COPY public.config FROM '/data/upp-2020-10-28_21.config.data' with binary;"
вот вывод при восстановлении из upp-2020-10-28_21.backup:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
pg_restore: from TOC entry 248; 1259 157692 TABLE _acc13 postgres
pg_restore: error: could not execute query: ERROR: table "_acc13" does not exist
Command was: DROP TABLE public._acc13;
pg_restore: from TOC entry 247; 1259 157686 TABLE _acc12_extdim21591 postgres
pg_restore: error: could not execute query: ERROR: table "_acc12_extdim21591" does not exist
Command was: DROP TABLE public._acc12_extdim21591;
pg_restore: from TOC entry 246; 1259 157679 TABLE _acc12 postgres
pg_restore: error: could not execute query: ERROR: table "_acc12" does not exist
Command was: DROP TABLE public._acc12;
pg_restore: from TOC entry 26221; 2753 157678 OPERATOR FAMILY reltime_fill_ops postgres
pg_restore: error: could not execute query: ERROR: operator family "public.reltime_fill_ops" does not exist for access method "hash"
Command was: DROP OPERATOR FAMILY public.reltime_fill_ops USING hash;
pg_restore: from TOC entry 26220; 2753 157677 OPERATOR FAMILY abstime_fill_ops postgres
pg_restore: error: could not execute query: ERROR: operator family "public.abstime_fill_ops" does not exist for access method "hash"
Command was: DROP OPERATOR FAMILY public.abstime_fill_ops USING hash;
pg_restore: from TOC entry 25059; 1255 157676 AGGREGATE min(bytea) postgres
pg_restore: error: could not execute query: ERROR: aggregate public.min(bytea) does not exist
Command was: DROP AGGREGATE public.min(bytea);
pg_restore: from TOC entry 25058; 1255 157675 AGGREGATE min(boolean) postgres
pg_restore: error: could not execute query: ERROR: aggregate public.min(boolean) does not exist
Command was: DROP AGGREGATE public.min(boolean);
pg_restore: from TOC entry 25057; 1255 157674 AGGREGATE max(bytea) postgres
pg_restore: error: could not execute query: ERROR: aggregate public.max(bytea) does not exist
Command was: DROP AGGREGATE public.max(bytea);
pg_restore: from TOC entry 25056; 1255 157673 AGGREGATE max(boolean) postgres
pg_restore: error: could not execute query: ERROR: aggregate public.max(boolean) does not exist
Command was: DROP AGGREGATE public.max(boolean);
pg_restore: from TOC entry 5257; 1255 157672 FUNCTION vassn(boolean) postgres
pg_restore: error: could not execute query: ERROR: function public.vassn(boolean) does not exist
Command was: DROP FUNCTION public.vassn(boolean);
pg_restore: from TOC entry 5256; 1255 157671 FUNCTION state_min_bytea(bytea, bytea) postgres
pg_restore: error: could not execute query: ERROR: function public.state_min_bytea(bytea, bytea) does not exist
Command was: DROP FUNCTION public.state_min_bytea(st bytea, inp bytea);
pg_restore: from TOC entry 5255; 1255 157670 FUNCTION state_min_bool(boolean, boolean) postgres
pg_restore: error: could not execute query: ERROR: function public.state_min_bool(boolean, boolean) does not exist
Command was: DROP FUNCTION public.state_min_bool(st boolean, inp boolean);
pg_restore: from TOC entry 5254; 1255 157669 FUNCTION state_max_bytea(bytea, bytea) postgres
pg_restore: error: could not execute query: ERROR: function public.state_max_bytea(bytea, bytea) does not exist
Command was: DROP FUNCTION public.state_max_bytea(st bytea, inp bytea);
pg_restore: from TOC entry 5253; 1255 157668 FUNCTION state_max_bool(boolean, boolean) postgres
pg_restore: error: could not execute query: ERROR: function public.state_max_bool(boolean, boolean) does not exist
Command was: DROP FUNCTION public.state_max_bool(st boolean, inp boolean);
pg_restore: from TOC entry 5252; 1255 157667 FUNCTION plpgsql_call_handler() postgres
pg_restore: error: could not execute query: ERROR: function public.plpgsql_call_handler() does not exist
Command was: DROP FUNCTION public.plpgsql_call_handler();
pg_restore: from TOC entry 5251; 1255 157666 FUNCTION datediff2(character varying, timestamp without time zone, timestamp without time zone) postgres
pg_restore: error: could not execute query: ERROR: function public.datediff2(character varying, timestamp without time zone, timestamp without time zone) does not exist
Command was: DROP FUNCTION public.datediff2(character varying, timestamp without time zone, timestamp without time zone);
pg_restore: from TOC entry 5250; 1255 157665 FUNCTION datediff(character varying, timestamp without time zone, timestamp without time zone) postgres
pg_restore: error: could not execute query: ERROR: function public.datediff(character varying, timestamp without time zone, timestamp without time zone) does not exist
Command was: DROP FUNCTION public.datediff(character varying, timestamp without time zone, timestamp without time zone);
pg_restore: from TOC entry 5249; 1255 157664 FUNCTION btrim(bytea, integer) postgres
pg_restore: error: could not execute query: ERROR: function public.btrim(bytea, integer) does not exist
Command was: DROP FUNCTION public.btrim(bdata bytea, blen integer);
pg_restore: from TOC entry 5248; 1255 157663 FUNCTION binrowver(integer) postgres
pg_restore: error: could not execute query: ERROR: function public.binrowver(integer) does not exist
Command was: DROP FUNCTION public.binrowver(p1 integer);
pg_restore: from TOC entry 4; 3079 156615 EXTENSION mchar (no owner)
pg_restore: error: could not execute query: ERROR: extension "mchar" does not exist
Command was: DROP EXTENSION mchar;
pg_restore: from TOC entry 2; 3079 157494 EXTENSION fulleq (no owner)
pg_restore: error: could not execute query: ERROR: extension "fulleq" does not exist
Command was: DROP EXTENSION fulleq;
pg_restore: from TOC entry 3; 3079 157492 EXTENSION fasttrun (no owner)
pg_restore: error: could not execute query: ERROR: extension "fasttrun" does not exist
Command was: DROP EXTENSION fasttrun;
