LCM based deployments and the installer for Aria Config ship with Postgresql 13. This version of Postgresql is only supported until November 13, 2025. See https://www.postgresql.org/support/versioning/ for more information on the Postgresql support life cycle.
Tanzu Salt - all versions
Aria Config - all versions
Aria Config should work with any recent version of Postgresql, but customers are currently recommended to run Postgresql 15, which has support by Postgresql until November, 2027 as noted on this page by Postgresql, https://www.postgresql.org/support/versioning/ .