Support for building and testing PSQL-16 on C10S replace nss-wrapper with nss-wrapper-libs

[phracek]

This pull request allows to build and test PSQL-16 on C10S

The pull request is separated into more commits:

• Update dist-gen sources
• dist-gen generated sources
• update imagestreams for C10S
• update build and push with postgresql-16-c10s
• Do not fix /run/postgresql and even /var/run/postgresql dirs. The first one is %ghost directory and the second one does not exist

[phracek]

[test]

[phracek]

[test]

[hhorak]

The only change that seems to be worth doing is simplifying INSTALL_PKGS definition and remove the rhscl specifics (brew links etc.) and since we have gettext-envsubst available in the RHEL-10/c10s, and nss_wrapper-libs everywhere now, we might simplify it to:

RUN {{ spec.environment_setup }}
{% if spec.prod in [ "rhel8", "rhel9", "c9s" ] %}
    INSTALL_PKGS="rsync tar gettext bind-utils nss_wrapper-libs {{ spec.pkgs }}" && \
{% else %}
    INSTALL_PKGS="rsync tar gettext-envsubst bind-utils nss_wrapper-libs {{ spec.pkgs }}" && \
{% endif %}

(have not tried yet, mentioning to better describe my intention)

[phracek]

RUN {{ spec.environment_setup }}

@hhorak It cannot be used because the module is unavailable for C10S.
See https://github.com/sclorg/postgresql-container/blob/master/specs/multispec.yml#L41

I will fix it good catch.

[phracek]

[test]

[phracek]

[test-all]

[phracek]

Fedora 15 has failed for this reason:

-----------------------------------------------
Running test run_s2i_enable_ssl_test (starting at 2024-09-06 13:36:21+00:00) ... 
-----------------------------------------------
3b84e71e4d32e2887d7750409d1485a852cc94cd06dee58693a5c6d632da0f6c
Created container 3b84e71e4d32e2887d7750409d1485a852cc94cd06dee58693a5c6d632da0f6c
double free or corruption (out)
/usr/libexec/check-container: line 27:    63 Aborted                 (core dumped) pg_isready -q -h 127.0.0.1 ${POSTGRESQL_USER+-U "$POSTGRESQL_USER"} ${POSTGRESQL_DATABASE+-d "$POSTGRESQL_DATABASE"} --timeout 0
double free or corruption (out)

==============================================
Tests were run for image quay.io/fedora/postgresql-15:0
==============================================
Test cases results:

 [FAILED] for 'postgresql-container_tests' run_s2i_enable_ssl_test (00:00:40)

CEntOS Stream 10 - 16 has failed for this reason:

-----------------------------------------------
Running test run_s2i_bake_data_test (starting at 2024-09-06 13:38:17+00:00) ... 
-----------------------------------------------
  ERROR: Failed to to build /tmp/tmp.ABtq1DrUYk/Dockerfile.7a8X
Trying to pull quay.io/sclorg/postgresql-16-c10s:1-bake_8gumrrdgqn...
Error: initializing source docker://quay.io/sclorg/postgresql-16-c10s:1-bake_8gumrrdgqn: reading manifest 1-bake_8gumrrdgqn in quay.io/sclorg/postgresql-16-c10s: unauthorized: access to the requested resource is not authorized
ERROR: Creation of container didn't succeed
cat: /tmp/tmp.QBX49KryMq/bake-data-test: No such file or directory
Error: name or ID cannot be empty
cat: /tmp/tmp.QBX49KryMq/bake-data-test: No such file or directory

The complete results for CentOS Stream 10 are:

==============================================
Tests were run for image quay.io/sclorg/postgresql-16-c10s:1
==============================================
Test cases results:

 [PASSED] for 'postgresql-container_tests' run_container_creation_tests (00:00:26)
 [PASSED] for 'postgresql-container_tests' run_general_tests (00:00:44)
 [PASSED] for 'postgresql-container_tests' run_change_password_test (00:00:09)
 [PASSED] for 'postgresql-container_tests' run_replication_test (00:00:05)
 [PASSED] for 'postgresql-container_tests' run_doc_test (00:00:01)
 [PASSED] for 'postgresql-container_tests' run_s2i_test (00:00:17)
 [PASSED] for 'postgresql-container_tests' run_test_cfg_hook (00:00:11)
 [FAILED] for 'postgresql-container_tests' run_s2i_bake_data_test (00:00:28)
 [PASSED] for 'postgresql-container_tests' run_s2i_enable_ssl_test (00:00:09)
 [PASSED] for 'postgresql-container_tests' run_upgrade_test (00:00:01)
 [PASSED] for 'postgresql-container_tests' run_migration_test (00:00:02)
 [PASSED] for 'postgresql-container_tests' run_pgaudit_test (00:00:03)
 [PASSED] for 'postgresql-container_tests' run_new_pgaudit_test (00:00:03)
 [PASSED] for 'postgresql-container_tests' run_logging_test (00:00:02)

[phracek]

The failure on C10S is:

+ psql -f /tmp/src/init/init.sql
CREATE TABLE
INSERT 0 1
waiting for server to shut down....+ pg_ctl stop
 done
server stopped
+ tar caf data.tar.xz -C /var/lib/pgsql/data/userdata .
/bin/sh: line 1: xz: command not found
tar: data.tar.xz: Wrote only 4096 of 10240 bytes

[phracek]

[test]

[phracek]

CentOS Stream 10 passed. We are GREEN.

[phracek]

[test]

[phracek]

@hhorak @SlouchyButton Ready to re-review and merge. C10S passed.

[phracek]

[test]

[phracek]

[test]

[phracek]

Fix package dependencies
[test]

[phracek]

[test]