Re: testing pg_dump against very old versions
От | Andrew Dunstan |
---|---|
Тема | Re: testing pg_dump against very old versions |
Дата | |
Msg-id | 225660d5-8a1b-2047-daca-6870ec3d0868@2ndQuadrant.com обсуждение исходный текст |
Ответ на | testing pg_dump against very old versions (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>) |
Список | pgsql-hackers |
On 09/22/2018 12:46 PM, Andrew Dunstan wrote: > > 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. > > OK, the repo now has a Dockerfile, and I have pushed a Docker image to dockerhub. It can be pulled as andrewdunstan/postgres:pg7.2.8 That should make it easy enough for many people to play with. For testing, I think we'll need a way to specify where to connect to. One simple way might be to set an environnment variable, like REL7_2_TEST_CONNINFO="hostname=192.168.129.156 port=5478 user=postgres". But ideally we want more than that - possibly some pre and post test commands, such as "ssh dockerhost docker run -d --name pg72 -p 5478:5432 mycontainer" and "ssh dockerhost kill pg72". this would be easily manageable in a buildfarm context, not sure how we should manage it in core code, though. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services q
В списке pgsql-hackers по дате отправления: