On 5/3/16 1:25 PM, Alvaro Herrera wrote:
If we can put together a script that runs test.sh for various versions and then verifies the runs, we could use it in both buildfarm and coverage.
Not that that would be useless, but note that the value in this case (and most others) comes from having a candidate object in the database before upgrade that exercises the particular problem, mostly independent of what version you upgrade from and to. So far the way to do that is to leave "junk" in the regression test database, but that's clearly a bit silly.
I think the way forward is to create a TAP test suite for pg_upgrade that specifically exercises a lot of scenarios with small purpose-built test databases.
Then, the problem of having to compare dump output across versions also goes away more easily.
-- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers