In the interest of advancing $subject, I recently started a little
skunkworks project to get old postgres running on modern systems so we
could test if we'd broken backwards compatibility somehow. This was
given a fillip a few days ago when my colleague Gianni Ciolli complained
that it uses array syntax that isn't valid in 7.3 for the -T option. So
here is the result. Essentially I set up a (barely workable) Fedora Core
2 VM and build Postgres 7.2.8 there. Then I packed up the binaries and
data directory and tried them on a modern system (Fedora 28). It turns
out they need a few old libraries, but apart from that it works. So I
have packaged all this up in a Vagrant setup, which is available at
<https://bitbucket.org/adunstan/oldpg>
Next I'm going to work on a Docker image for this. I think that should
be fairly simple now I have this piece down.
Then I will start adding other old versions.
Meanwhile, it would be good for people to think about creating a TAP
testing regime for this.
cheers
andrew
--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
