Since libpq is dependency of python-psycopg2, it would be enough to add a basic test for python-psycopg2 and run it also in CI for libpq

Package libpq is since RHEL9 only used to connect to database when using some connectors. Known for use python-psycopg2.

Due to that it is neccessary to adjust testing plans for this component for RHEL9 and RHEL10 to test just with python-psycopg2 and not whole postgresql testsuite.

Expected outcome:

1. Prepare a simple libpq sanity test in C
   1. git clone ssh://pkgs.devel.redhat.com/tests/libpq
   2. tmt test create ./<TEST NAME> -t beakerlib
   3. open test.sh and write test. You can use beakerlib wrapper: https://beakerlib.readthedocs.io/en/latest/manual.html
      1. If you need to test the package/commands you can reserve machine with 1minutetip -nu rhel8/9/10 and test it there.
   4. You can try to run the test with: tmt run -avvv --skip finish plan --default execute --how tmt --interactive test --name . provision --how minute --image rhel10 login

1. Stabilize or rewrite sanity test for python-psycopg2 for RHEL8,9,10.
   1. git clone ssh://pkgs.devel.redhat.com/tests/python-psycopg2
   2. go to every test directory, check that it contains main.fmf and try: tmt run -avvv --skip finish plan --default execute --how tmt --interactive test --name . provision --how minute --image rhel10 login - Change rhel10 to rhel8/9

1. Test plan for libpq using these test cases for RHEL9 and 10..
   1. Add gating.yaml and plans.fmf with link to the plans into https://gitlab.com/redhat/centos-stream/rpms/libpq c10s and c9s branch by forking repo
   2. Add plans to the wanted repository fedora/rhel tests
      1. Plans should contain Tier1/2/3 plan and discover tests from libpq and python_psycopg2 repo (You can take inspiration here)
         1. If you need to create fedora tests repo you can reguest it by this command: fedpkg request-tests-repo libpq "Public libpq tests"
2. Adjusted gating for RHEL9 and RHEL10 to use this plan.

Check with fjanus, if it neccessary to test against are supported postgresql modules on RHEL9 and postgresql version on RHEL10.