HDP and Postgres versions

[#1]

I have a HDP 2.6 cluster that I want to upgrade to HDP 3.1. I currently use postgres 9.2 for Ambari, and a separate postgres 9.2 instance for Ranger and Hive. Looking at the compatibility matrix, postgres 9.2 is no longer supported for HDP 3.1.

1) Does this apply just to the postgres instance used by ambari, or also to the postgres instance used by Ranger and Hive too?

2) I'm assuming upgrading postgres isn't handled by ambari, so should I just upgrade and migrate the relevant data, keeping the connection parameters the same?

Thanks in advance

[#2]

Thanks very much, that makes sense.