Add nightly specs for Postgres 16

With PostgreSQL 16 released, we should add specs ensuring we have a basic level of compatibility for customers who run external databases who choose to run 16. This work is similar to that done in Update tested postgres versions (#402982 - closed)

Deliverable

• Add nightly tests for PostgreSQL 16