There is an issue when doing Hive Metadata replication to a DR site with Postgres.
When the replication is started, the entire PostgreSQL is in standby state on the DR site. This means changes to Ambari and Ranger (which are also using Postgres) can’t be done in parallel using APIs because the database is in a read only state.
Has this been seen before? What recommendation are there to work around it?