PG16: add more CI workflows from main #50

Job	Run time
check-skip	3s
prepare-test-matrix	4s
Build Apache Cloudberry RPM (Rocky 8)	2m 24s
Generate Apache Cloudberry Build Report (Rocky 8)	4s
${{ matrix.test }} (Rocky 8)	0s
RPM Install Test Apache Cloudberry (Rocky 8)	0s
	2m 35s

Provide feedback