>> Pi OS has had a 64-bit version for two years now, so I think that would be
>> the way to go for anyone needing compatibility.
And Debian's Pi images for even longer. As long as your Postgres server doesn't need proprietary GPU-accelerated video codecs, I strongly recommend using these.
-nik