pgsql: ci: Per-repo configuration for manually trigger tasks

ci: Per-repo configuration for manually trigger tasks

We do not want to trigger some tasks by default, to avoid using too many
compute credits. These tasks have to be manually triggered to be run. But
e.g. for cfbot we do have sufficient resources, so we always want to start
those tasks.

With this commit, an individual repository can be configured to trigger
them automatically using an environment variable defined under
"Repository Settings", for example:

REPO_CI_AUTOMATIC_TRIGGER_TASKS="mingw netbsd openbsd"

This will enable cfbot to turn them on by default when running tests for the
Commitfest app.

Backpatch this back to PG 15, even though PG 15 does not have any manually
triggered task. Keeping the CI infrastructure the same seems advantageous.

Author: Andres Freund <andres(at)anarazel(dot)de>
Co-authored-by: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Co-authored-by: Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>
Reviewed-by: Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>
Discussion: https://postgr.es/m/20240413021221.hg53rvqlvldqh57i%40awork3.anarazel.de
Backpatch-through: 16

Branch
------
REL_18_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/faa78bc1c1d4efaeef7dc6703e69aef4c6e017c3

Modified Files
--------------
.cirrus.star | 50 ++++++++++++++++++++++++++++++++++++++++++++++----
.cirrus.tasks.yml | 15 ++++++++-------
.cirrus.yml | 12 ++++++++++--
src/tools/ci/README | 11 +++++++++++
4 files changed, 75 insertions(+), 13 deletions(-)