cancel
Showing results for 
Search instead for 
Did you mean: 

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

05 Base Camper

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

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,

 

1 ACCEPTED SOLUTION

Accepted Solutions

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

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).


If my answer helped you today, please be sure to mark the resolved button to assist others.

Christopher R Souser - Solution Architect – MSci. PA, CISSP, ITIL.

View solution in original post

Tags (1)
1 REPLY 1

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

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).


If my answer helped you today, please be sure to mark the resolved button to assist others.

Christopher R Souser - Solution Architect – MSci. PA, CISSP, ITIL.

View solution in original post

Tags (1)
Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar