If necessary, you can back up the EAS PostgreSQL database the Identity Reporting uses to store audit data, event data, and configuration information. The database contains three separate schemas:
public: Stores audit data, event source configuration information, and other administrative information.
EAS stores audit data for 90 days. It purges (deletes) the events that are older than 90 days. If you have a requirement to maintain audit data for more than 90 days, ensure you back up the public schema on the PostgreSQL database in the EAS server using the PostgreSQL tools or backup_util.sh utility provided with Identity Manager. For more information about backing up and restoring data, see Backing Up and Restoring the Public Schema.
idm_rpt_data: Stores data collected by the Managed System Gateway Driver and the Data Collection Service Driver, as well as data collection configuration information.
EAS stores this data based on the value specified for the Keep collected reporting data for setting on the Settings page. The default value is 365 days. For more information about backing up and restoring data, see Backing Up and Restoring the idm_rpt_data and idm_rpt_cfg Schemas.
idm_rpt_cfg: Stores reporting configuration information, reports, and report scheduling information.
EAS stores this data as long as you do not perform a purge operation using a REST end point. For more information about backing up and restoring data, see Backing Up and Restoring the idm_rpt_data and idm_rpt_cfg Schemas.
If you have a requirement to use a real time auditing solution, use NetIQ Sentinel and set up the Sentinel link to EAS.
This process includes the following activities:
NetIQ recommends that you use the standard PostgreSQL backup and restore procedures to back up or restore the idm_rpt_data and idm_rpt_cfg schemas. For detailed information on backing up and restoring PostgreSQL databases, see Backup and Restore
in the PostgreSQL documentation
To back up the public schema, use the backup_util.sh utility provided with Identity Manager. The utility is located in the /opt/novell/sentinel/bin directory on the Identity Manager server.
To backup and restore the public schema:
Create a .pgpass file in the /home/novleas directory and ensure that it meets the following conditions:
The file owner is novleas.
The file does not allow any access to world or group. If necessary, use the chmod 0600 command to restrict access.
Use the format hostname:port:database:username:password. For example, localhost:15432:*:dbauser:novell.
On the Identity Manager server, log in as root and then use the su command to switch to the novleas user.
Navigate to /opt/novell/sentinel_eas/bin.
Issue the following command:
./backup_util.sh -backup . -online -config_only -no_logs
Ensure that the PostgreSQL database to which you will restore the schema is empty.
Issue the following command:
./backup_util.sh -restore . -online -config_only -no_logs
For more information, see Backing Up and Restoring Data
in the NetIQ Sentinel Administration Guide.