Regarding PostgreSQL versions: the main source of incompatibilities across PostgreSQL releases typically arises when legacy features are removed in newer versions. Fortunately, such changes are relatively rare. As a result, OpenACS continues to work unchanged with many recently released PostgreSQL versions.
For example, the DB-inclusive OpenACS container setup runs successfully with the currently newest release, i.e. PostgreSQL 18 (see [1]).
all the best
-g
https://github.com/gustafn/docker-ns/tree/main/examples/oacs-db-inclusive