Hi, I would like to know how the recipe for hive should be when postgres is used as the metastore

Try using the recipe mentioned in the Docs. We are using the same recipe with oracle as a metastore. No issues so far.

It worked for me. Thanks