[Enhancement]: Support postgresql version of bitnami variant

[rajadilipkolli]

Module

PostgreSQL

Proposal

When attempting to utilize a Bitnami PostgreSQL container within a Spring Boot application's test environment (specifically, with Testcontainers), we're encountering an issue related to custom configuration.

The core problem arises from the necessity to set the fsync=off parameter for PostgreSQL. It looks like that Bitnami's version does not support this configuration, or at least the entrypoint cannot handle it.

Below is the sample which I want to work with testcontainers.

Map<String, String> envMap = new HashMap<>();
        envMap.put("POSTGRESQL_REPLICATION_MODE", "slave");
        envMap.put("POSTGRESQL_REPLICATION_USER", "repl_user");
        envMap.put("POSTGRESQL_REPLICATION_PASSWORD", "repl_password");
        envMap.put("POSTGRESQL_USERNAME", "postgres_write");
        envMap.put("POSTGRESQL_PASSWORD", "postgres_write");

        PostgreSQLContainer<?> slave =
                new PostgreSQLContainer<>(
                                DockerImageName.parse("bitnami/postgresql:latest")
                                        .asCompatibleSubstituteFor("postgres"))
                        .withEnv(envMap)

Request to support bitnami version of postgresql

[eddumelendez]

The problem with postgres is not only with the fsync=off command but also the wait strategy

▶ docker run --rm -ePOSTGRESQL_PASSWORD=testcontainers bitnami/postgresql:latest
postgresql 22:43:07.05 INFO  ==>
postgresql 22:43:07.05 INFO  ==> Welcome to the Bitnami postgresql container
postgresql 22:43:07.05 INFO  ==> Subscribe to project updates by watching https://github.com/bitnami/containers
postgresql 22:43:07.05 INFO  ==> Submit issues and feature requests at https://github.com/bitnami/containers/issues
postgresql 22:43:07.05 INFO  ==> Upgrade to Tanzu Application Catalog for production environments to access custom-configured and pre-packaged software components. Gain enhanced features, including Software Bill of Materials (SBOM), CVE scan result reports, and VEX documents. To learn more, visit https://bitnami.com/enterprise
postgresql 22:43:07.05 INFO  ==>
postgresql 22:43:07.07 INFO  ==> ** Starting PostgreSQL setup **
postgresql 22:43:07.08 INFO  ==> Validating settings in POSTGRESQL_* env vars..
postgresql 22:43:07.08 INFO  ==> Loading custom pre-init scripts...
postgresql 22:43:07.09 INFO  ==> Initializing PostgreSQL database...
postgresql 22:43:07.10 INFO  ==> pg_hba.conf file not detected. Generating it...
postgresql 22:43:07.10 INFO  ==> Generating local authentication configuration
postgresql 22:43:07.63 INFO  ==> Starting PostgreSQL in background...
postgresql 22:43:08.65 INFO  ==> Changing password of postgres
postgresql 22:43:08.68 INFO  ==> Configuring replication parameters
postgresql 22:43:08.70 INFO  ==> Configuring synchronous_replication
postgresql 22:43:08.70 INFO  ==> Configuring fsync
postgresql 22:43:08.72 INFO  ==> Stopping PostgreSQL...
waiting for server to shut down.... done
server stopped
postgresql 22:43:08.82 INFO  ==> Loading custom scripts...
postgresql 22:43:08.83 INFO  ==> Enabling remote connections
postgresql 22:43:08.83 INFO  ==> ** PostgreSQL setup finished! **

postgresql 22:43:08.85 INFO  ==> ** Starting PostgreSQL **
2024-11-05 22:43:08.863 GMT [1] LOG:  pgaudit extension initialized
2024-11-05 22:43:08.871 GMT [1] LOG:  starting PostgreSQL 17.0 on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-11-05 22:43:08.871 GMT [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-11-05 22:43:08.871 GMT [1] LOG:  listening on IPv6 address "::", port 5432
2024-11-05 22:43:08.872 GMT [1] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
2024-11-05 22:43:08.874 GMT [126] LOG:  database system was shut down at 2024-11-05 22:43:08 GMT
2024-11-05 22:43:08.878 GMT [1] LOG:  database system is ready to accept connections

PostgreSQLContainer's wait strategy expects database system is ready to accept connections to be displayed twice in logs. Current container implementations are based on specific images and those who are created based on those and that's the reason of Image Substitution.

We have been looking into the Bitnami's images recently and it offers a great way to configure services. We think it would be nice if there is a Testcontainers Bitnami project that offers its own modules.