Add PostgreSQL 16 as opt-in for fresh installs

Note the migrations section of 16.0 and 16.1.

This is a followon to #8422 (closed)

Previous work was here: !6811 (merged)