Version SQLBackupAndFTP 12.7.0
29.06.2022 20:19:26 [Error] Failed to restore “torg” database. pg_restore error: pg_restore: WARNING: operator attribute “function” not recognized
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 10890; 2617 1513240 OPERATOR > postgres
pg_restore: error: could not execute query: ERROR: operator procedure must be specified
Command was: CREATE OPERATOR public.> (
FUNCTION = public.mchar_icase_gt,
LEFTARG = public.mchar,
RIGHTARG = public.mchar,
COMMUTATOR = OPERATOR(public.<),
NEGATOR = OPERATOR(public.<=),
RESTRICT = sca… INDEX byname ON public.v8users USING btree (name);
pg_restore: from TOC entry 12955; 1259 1688552 INDEX byosname postgres
pg_restore: error: could not execute query: ERROR: data type public.mvarchar has no default operator class for access method “btree”
HINT: You must specify an operator class for the index or define a default operator class for the data type.
Command was: CREATE INDEX byosname ON public.v8users USING btree (osname);
pg_restore: warning: errors ignored on restore: 1176
29.06.2022 11:35 Connecting to “PostgreSQL Server”: “sfera”.
29.06.2022 11:35 Connected to “PostgreSQL 9.6.7, compiled by Visual C++ build 1800, 64-bit”.
29.06.2022 11:35 Connecting to “Folder” destination “\192.168.5.100\sql\All”.
29.06.2022 11:35 Searching files by mask “torg*.*”.
29.06.2022 11:35 Found “15” files.
29.06.2022 11:35 Getting “torg202206232100.tar” file metadata on “\192.168.5.100\sql\All” folder.
29.06.2022 11:35 Downloading file “torg202206232100.tar” to “G:\Temp\Pranas.NET\SBF\backup\baebcc960dfa4149853d6dad6ece62d2\torg\23.06.2022 21_00_00”.
29.06.2022 11:55 Restoring “torg” database from files: “torg202206232100.tar”.
29.06.2022 13:19 Failed to restore “torg” database. pg_restore error: pg_restore: WARNING: operator attribute “function” not recognized
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 10890; 2617 1513240 OPERATOR > postgres
pg_restore: error: could not execute query: ERROR: operator procedure must be specified
Command was: CREATE OPERATOR public.> (
FUNCTION = public.mchar_icase_gt,
LEFTARG = public.mchar,
RIGHTARG = public.mchar,
COMMUTATOR = OPERATOR(public.<),
NEGATOR = OPERATOR(public.<=),
RESTRICT = sca… INDEX byname ON public.v8users USING btree (name);
pg_restore: from TOC entry 12955; 1259 1688552 INDEX byosname postgres
pg_restore: error: could not execute query: ERROR: data type public.mvarchar has no default operator class for access method “btree”
HINT: You must specify an operator class for the index or define a default operator class for the data type.
Command was: CREATE INDEX byosname ON public.v8users USING btree (osname);
pg_restore: warning: errors ignored on restore: 1176
29.06.2022 13:19 Disconnecting from “Folder” destination “\192.168.5.100\sql\All”.
29.06.2022 13:19 Deleting temporary files.
29.06.2022 13:19 Job “Restore Job - 2” finished with “1” errors.