Restore backup hive metastore

[#1]

Hi:

I have locally in a postgres database the hivemetastore, but now we will migrate to a remote metastore with a postgres database also

-Is necesary to migrate the hive metastore database to the new postgres instance?

-Is necesary to shut down the cluster?

Thanks

[#2]

@Roberto Sancho

1. If you need any detail from the backup then you MUST migrate the hive metastore backup to new postgres instance.

2. To ensure that the backup is applied correctly and that there are no inconsistencies, you must shut down the Hive Instance/Metastore then apply the backup, do quick consistency checks and then restart hive metastore and the instance.

[#3]

Many thanks for the information!!

Is not necesary to shut down de Namenode?

thanks

[#4 · Accepted solution]

@Roberto Sancho

1. If you need any detail from the backup then you MUST migrate the hive metastore backup to new postgres instance.

2. To ensure that the backup is applied correctly and that there are no inconsistencies, you must shut down the Hive Instance/Metastore then apply the backup, do quick consistency checks and then restart hive metastore and the instance.

3. You only need to shutdown Hive Metastore/Instance. No other component needs to be shutdown.