Prognosis 11.9 I want to use pgAdmin4 to backup restore WebUI custom Navigation view.

[Alain]

Prognosis 11.9 Managed Node I want to use pgAdmin4 to backup restore WebUI custom Navigation view.

On the management node I have added via the WebUI a lot of custom Navigation views over time and I want to backup it. Which Schemas in pgAdmin4 correspond to the custom Navigation view.

I already know the irrbs correcpond to the Security.

Also if you can provide the role of each Schemas.

- iralertmap

- ircra

- irha

- irrbs = Security

- public

- sysviews

Thanks,

[ChristopherS · Accepted solution]

I believe the Custom Navigations (and navigations in general) are currently contained entirely in the *.owl files located in the \Prognosis\WebUI\ directory structure (under dashboard). You will see the queries they issue to determine nodes to display in them. 

SYSVIEWS is the all 'active' and 'persistent' views are stored under sysviews schema in Postgres. 

IRHA is used for Prognosis HA if licensed

IRCRA is used for IRCRA's product if licensed

IRRBS is used for WebUI roles and security; though some of it is in SysViews as well I believe.

PUBLIC is the default schema for anything user created that can then be access via PQL (with proper syntax).