DBPaaS: How to refresh Materialized View for AWS PostgreSQL databases(s)

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