Add Postgres 16 to nightly rspec builds

What does this MR do and why?

Adds Postgres 16 to nightly test runs.

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #425470 (closed)