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 postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot drop rule _RETURN on view clientgroups_view because view clientgroups_view requires it
HINT: 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 postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot drop rule _RETURN on view policies_view because view policies_view requires it
HINT: 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 postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot drop rule _RETURN on view rasdevices_view because view rasdevices_view requires it
HINT: You can drop view rasdevices_view instead.
Command was: DROP RULE "_RETURN" ON public.rasdevices_view;