Important Update: Cohesity Products Knowledge Base Articles
All Cohesity Knowledge Base Articles are now managed via the Cohesity Support Portal: https://support.cohesity.com/s/searchunify. The Knowledge Base articles available here will not reflect the latest information or may no longer be accessible.
Prerequisites:
1. FQDN of the restored database.
2. Valid restore database user credentials of the restored database.
3. Install the PostgreSQL client utilities i.e psql.
4. The target instance must be able to connect to the media server.
Perform these steps to refresh the materialized views present on the restored database:
1. Connect to the PostgreSQL instance of the restored database (get the restored database name from restore job details) using the command: psql -h <restore_database_target_instance_fqdn> -U <restore_database_user> -W -d <restore_database_name>
2. Verify if the Materialized views are successfully restored to the restored database using the command: \dm+ *.*;
3. If all the Materialized views are present in the restored database, to refresh Materialized views in the restored database, use the script available at: /usr/openv/netbackup/ext/db_ext/dbpaas/postgresql/samples/scripts/postgresql_restore_database_refresh_materialized_view_script_1.0.sql
4. Command to run the script: \i postgresql_restore_database_refresh_materialized_view_script_1.0.sql
Was this content helpful?
Translated Content
Please note that this document is a translation from English, and may have been machine-translated. It is possible that updates have been made to the original version after this document was translated and published. Veritas does not guarantee the accuracy regarding the completeness of the translation. You may also refer to the English Version of this knowledge base article for up-to-date information.