pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Move into separate file all the SQL queries used in pg_upgrade t 6+ messages / 1 participants [nested] [flat]
* pgsql: Move into separate file all the SQL queries used in pg_upgrade t @ 2021-12-02 01:33 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 6+ messages in thread From: Michael Paquier @ 2021-12-02 01:33 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Move into separate file all the SQL queries used in pg_upgrade tests The existing pg_upgrade/test.sh and the buildfarm code have been holding the same set of SQL queries when doing cross-version upgrade tests to adapt the objects created by the regression tests before the upgrade (mostly, incompatible or non-existing objects need to be dropped from the origin, perhaps re-created). This moves all those SQL queries into a new, separate, file with a set of \if clauses to handle the version checks depending on the old version of the cluster to-be-upgraded. The long-term plan is to make the buildfarm code re-use this new SQL file, so as committers are able to fix any compatibility issues in the tests of pg_upgrade with a refresh of the core code, without having to poke at the buildfarm client. Note that this is only able to handle the main regression test suite, and that nothing is done yet for contrib modules yet (these have more issues like their database names). A backpatch down to 10 is done, adapting the version checks as this script needs to be only backward-compatible, so as it becomes possible to clean up a maximum amount of code within the buildfarm client. Author: Justin Pryzby, Michael Paquier Discussion: https://postgr.es/m/20201206180248.GI24052@telsasoft.com Backpatch-through: 10 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/0df9641d39057f431655b92b8a490b89c508a0b3 Modified Files -------------- src/bin/pg_upgrade/test.sh | 52 ++------------------- src/bin/pg_upgrade/upgrade_adapt.sql | 91 ++++++++++++++++++++++++++++++++++++ 2 files changed, 96 insertions(+), 47 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Move into separate file all the SQL queries used in pg_upgrade t @ 2021-12-02 01:33 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 6+ messages in thread From: Michael Paquier @ 2021-12-02 01:33 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Move into separate file all the SQL queries used in pg_upgrade tests The existing pg_upgrade/test.sh and the buildfarm code have been holding the same set of SQL queries when doing cross-version upgrade tests to adapt the objects created by the regression tests before the upgrade (mostly, incompatible or non-existing objects need to be dropped from the origin, perhaps re-created). This moves all those SQL queries into a new, separate, file with a set of \if clauses to handle the version checks depending on the old version of the cluster to-be-upgraded. The long-term plan is to make the buildfarm code re-use this new SQL file, so as committers are able to fix any compatibility issues in the tests of pg_upgrade with a refresh of the core code, without having to poke at the buildfarm client. Note that this is only able to handle the main regression test suite, and that nothing is done yet for contrib modules yet (these have more issues like their database names). A backpatch down to 10 is done, adapting the version checks as this script needs to be only backward-compatible, so as it becomes possible to clean up a maximum amount of code within the buildfarm client. Author: Justin Pryzby, Michael Paquier Discussion: https://postgr.es/m/20201206180248.GI24052@telsasoft.com Backpatch-through: 10 Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b6dac98b05618c22bf357e5fcf23ad2419013439 Modified Files -------------- src/bin/pg_upgrade/test.sh | 52 ++------------------- src/bin/pg_upgrade/upgrade_adapt.sql | 91 ++++++++++++++++++++++++++++++++++++ 2 files changed, 96 insertions(+), 47 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Move into separate file all the SQL queries used in pg_upgrade t @ 2021-12-02 01:33 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 6+ messages in thread From: Michael Paquier @ 2021-12-02 01:33 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Move into separate file all the SQL queries used in pg_upgrade tests The existing pg_upgrade/test.sh and the buildfarm code have been holding the same set of SQL queries when doing cross-version upgrade tests to adapt the objects created by the regression tests before the upgrade (mostly, incompatible or non-existing objects need to be dropped from the origin, perhaps re-created). This moves all those SQL queries into a new, separate, file with a set of \if clauses to handle the version checks depending on the old version of the cluster to-be-upgraded. The long-term plan is to make the buildfarm code re-use this new SQL file, so as committers are able to fix any compatibility issues in the tests of pg_upgrade with a refresh of the core code, without having to poke at the buildfarm client. Note that this is only able to handle the main regression test suite, and that nothing is done yet for contrib modules yet (these have more issues like their database names). A backpatch down to 10 is done, adapting the version checks as this script needs to be only backward-compatible, so as it becomes possible to clean up a maximum amount of code within the buildfarm client. Author: Justin Pryzby, Michael Paquier Discussion: https://postgr.es/m/20201206180248.GI24052@telsasoft.com Backpatch-through: 10 Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/fae5f08e17193a8e0c8ca941e0bed4c4d105df14 Modified Files -------------- src/bin/pg_upgrade/test.sh | 41 +++--------------- src/bin/pg_upgrade/upgrade_adapt.sql | 80 ++++++++++++++++++++++++++++++++++++ 2 files changed, 85 insertions(+), 36 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Move into separate file all the SQL queries used in pg_upgrade t @ 2021-12-02 01:33 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 6+ messages in thread From: Michael Paquier @ 2021-12-02 01:33 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Move into separate file all the SQL queries used in pg_upgrade tests The existing pg_upgrade/test.sh and the buildfarm code have been holding the same set of SQL queries when doing cross-version upgrade tests to adapt the objects created by the regression tests before the upgrade (mostly, incompatible or non-existing objects need to be dropped from the origin, perhaps re-created). This moves all those SQL queries into a new, separate, file with a set of \if clauses to handle the version checks depending on the old version of the cluster to-be-upgraded. The long-term plan is to make the buildfarm code re-use this new SQL file, so as committers are able to fix any compatibility issues in the tests of pg_upgrade with a refresh of the core code, without having to poke at the buildfarm client. Note that this is only able to handle the main regression test suite, and that nothing is done yet for contrib modules yet (these have more issues like their database names). A backpatch down to 10 is done, adapting the version checks as this script needs to be only backward-compatible, so as it becomes possible to clean up a maximum amount of code within the buildfarm client. Author: Justin Pryzby, Michael Paquier Discussion: https://postgr.es/m/20201206180248.GI24052@telsasoft.com Backpatch-through: 10 Branch ------ REL_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b6e525648d723fb915c4bd376de62f4e28099189 Modified Files -------------- src/bin/pg_upgrade/test.sh | 41 +++--------------- src/bin/pg_upgrade/upgrade_adapt.sql | 80 ++++++++++++++++++++++++++++++++++++ 2 files changed, 85 insertions(+), 36 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Move into separate file all the SQL queries used in pg_upgrade t @ 2021-12-02 01:33 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 6+ messages in thread From: Michael Paquier @ 2021-12-02 01:33 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Move into separate file all the SQL queries used in pg_upgrade tests The existing pg_upgrade/test.sh and the buildfarm code have been holding the same set of SQL queries when doing cross-version upgrade tests to adapt the objects created by the regression tests before the upgrade (mostly, incompatible or non-existing objects need to be dropped from the origin, perhaps re-created). This moves all those SQL queries into a new, separate, file with a set of \if clauses to handle the version checks depending on the old version of the cluster to-be-upgraded. The long-term plan is to make the buildfarm code re-use this new SQL file, so as committers are able to fix any compatibility issues in the tests of pg_upgrade with a refresh of the core code, without having to poke at the buildfarm client. Note that this is only able to handle the main regression test suite, and that nothing is done yet for contrib modules yet (these have more issues like their database names). A backpatch down to 10 is done, adapting the version checks as this script needs to be only backward-compatible, so as it becomes possible to clean up a maximum amount of code within the buildfarm client. Author: Justin Pryzby, Michael Paquier Discussion: https://postgr.es/m/20201206180248.GI24052@telsasoft.com Backpatch-through: 10 Branch ------ REL_11_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/0e603b75c43417673b2b2a5ebdb5326bb9fc6a5b Modified Files -------------- src/bin/pg_upgrade/test.sh | 15 ++++------ src/bin/pg_upgrade/upgrade_adapt.sql | 58 ++++++++++++++++++++++++++++++++++++ 2 files changed, 63 insertions(+), 10 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Move into separate file all the SQL queries used in pg_upgrade t @ 2021-12-02 01:33 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 6+ messages in thread From: Michael Paquier @ 2021-12-02 01:33 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Move into separate file all the SQL queries used in pg_upgrade tests The existing pg_upgrade/test.sh and the buildfarm code have been holding the same set of SQL queries when doing cross-version upgrade tests to adapt the objects created by the regression tests before the upgrade (mostly, incompatible or non-existing objects need to be dropped from the origin, perhaps re-created). This moves all those SQL queries into a new, separate, file with a set of \if clauses to handle the version checks depending on the old version of the cluster to-be-upgraded. The long-term plan is to make the buildfarm code re-use this new SQL file, so as committers are able to fix any compatibility issues in the tests of pg_upgrade with a refresh of the core code, without having to poke at the buildfarm client. Note that this is only able to handle the main regression test suite, and that nothing is done yet for contrib modules yet (these have more issues like their database names). A backpatch down to 10 is done, adapting the version checks as this script needs to be only backward-compatible, so as it becomes possible to clean up a maximum amount of code within the buildfarm client. Author: Justin Pryzby, Michael Paquier Discussion: https://postgr.es/m/20201206180248.GI24052@telsasoft.com Backpatch-through: 10 Branch ------ REL_10_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/1924d508c33594541db287a065d394a781739b46 Modified Files -------------- src/bin/pg_upgrade/test.sh | 15 ++++------- src/bin/pg_upgrade/upgrade_adapt.sql | 51 ++++++++++++++++++++++++++++++++++++ 2 files changed, 56 insertions(+), 10 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2021-12-02 01:33 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2021-12-02 01:33 pgsql: Move into separate file all the SQL queries used in pg_upgrade t Michael Paquier <michael@paquier.xyz> 2021-12-02 01:33 pgsql: Move into separate file all the SQL queries used in pg_upgrade t Michael Paquier <michael@paquier.xyz> 2021-12-02 01:33 pgsql: Move into separate file all the SQL queries used in pg_upgrade t Michael Paquier <michael@paquier.xyz> 2021-12-02 01:33 pgsql: Move into separate file all the SQL queries used in pg_upgrade t Michael Paquier <michael@paquier.xyz> 2021-12-02 01:33 pgsql: Move into separate file all the SQL queries used in pg_upgrade t Michael Paquier <michael@paquier.xyz> 2021-12-02 01:33 pgsql: Move into separate file all the SQL queries used in pg_upgrade t Michael Paquier <michael@paquier.xyz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox