Would be nice if OpenACS could stay in tune with the current Debian stable version (unless there is a compelling technical reason for a newer version of postgres). The current Debian stable version is 7.4.x, so your policy is just right! Installing postgres from the source is not difficult, but apt-get makes life much easier.