Return
-
Title
How to restore the NVDB under NVBU 11.1.0.29 - Workaround to Bug 31749 -
Description
Using NetVault Backup 11.1.0.29, NetVault Database restores fail to restore the main NetVault Databases:
Auditor, Logs, Machines, Scheduler and Media database.
Trace will show:
Example for netvault_auditing:==================[pg_restore: [archiver (db)] Error while PROCESSING TOC:pg_restore: [archiver (db)] Error from TOC entry 3070; 2618 18326 RULE _RETURN postgrespg_restore: [archiver (db)] could not execute query: ERROR: cannot drop rule _RETURN on view clientgroups_view because view clientgroups_view requires itHINT: You can drop view clientgroups_view instead.Command was: DROP RULE "_RETURN" ON public.clientgroups_view;For netvault_scheduling:====================[pg_restore: [archiver (db)] Error while PROCESSING TOC:pg_restore: [archiver (db)] Error from TOC entry 3089; 2618 18270 RULE _RETURN postgrespg_restore: [archiver (db)] could not execute query: ERROR: cannot drop rule _RETURN on view policies_view because view policies_view requires itHINT: You can drop view policies_view instead.Command was: DROP RULE "_RETURN" ON public.policies_view;For netvault_mediamanagement:=========================[pg_restore: [archiver (db)] Error while PROCESSING TOC:pg_restore: [archiver (db)] Error from TOC entry 3382; 2618 18186 RULE _RETURN postgrespg_restore: [archiver (db)] could not execute query: ERROR: cannot drop rule _RETURN on view rasdevices_view because view rasdevices_view requires itHINT: You can drop view rasdevices_view instead.Command was: DROP RULE "_RETURN" ON public.rasdevices_view;
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.