community-images icon indicating copy to clipboard operation
community-images copied to clipboard

[Bug]: Various binaries for database clusters are not present in `rapidfort/postgresql-official:16.3-bookworm`

Open Vandit1604 opened this issue 9 months ago • 0 comments

Name and Version

rapidfort/postgresql-official:16.3-bookworm

Which runtime are you using to reproduce this issue?

  • [ ] Kubernetes
  • [ ] Docker Compose
  • [X] Docker

Is this issue reproducible on the original source image?

Reproducible

Could you please identify the category? Details in TROUBLE_SHOOTING.md

RF error

What steps will reproduce the bug?

I found that these functionalities are missing from rapidfort/postgresql-official:16.3-bookworm but they are present in postgres:16.3-bookworm

Most of these are important for database clusters

  1. pg_buildext: Compiles PostgreSQL extension modules.
  2. pg_conftool: Manages PostgreSQL configuration settings.
  3. pg_createcluster: Creates a new PostgreSQL cluster.
  4. pg_ctlcluster: Controls the operation of a PostgreSQL cluster.
  5. pg_dropcluster: Deletes an existing PostgreSQL cluster.
  6. pg_lsclusters: Lists the available PostgreSQL clusters.
  7. pg_renamecluster: Renames a PostgreSQL cluster.
  8. pg_backupcluster: Performs backup of a PostgreSQL cluster.
  9. pg_restorecluster: Restores a PostgreSQL cluster from backup.
  10. pg_upgradecluster: Upgrades a PostgreSQL cluster to a new major version.
  11. pg_virtualenv: Sets up a virtual environment for PostgreSQL.
  12. debconf-copydb: Copies PostgreSQL cluster configuration data between hosts.
  13. pg_updatedicts: Updates text search dictionaries in PostgreSQL.
  14. pg_rewind: Rewinds a PostgreSQL cluster's timeline to a previous state.
  15. pg_controldata: Displays control information of a PostgreSQL cluster.
  16. pg_upgrade: Upgrades a PostgreSQL data directory to a new major version.
  17. pg_test_fsync: Tests PostgreSQL's filesystem sync behavior.
  18. pg_checksums: Manages checksums for data files in a PostgreSQL cluster.
  19. pg_resetwal: Resets the write-ahead log in a PostgreSQL cluster.
  20. pg_waldump: Displays the contents of the write-ahead log in a human-readable format.

Are you using any custom parameters or values?

POSTGRES_PASSWORD=mypassword POSTGRESQL_USERNAME=postgres POSTGRESQL_DATABASE=my_database

What is the expected behavior?

Postgres should have all of these commands

What do you see instead?

bash-5.2# pg_buildext
bash: pg_buildext: command not found
bash-5.2# pg_conftool
bash: pg_conftool: command not found
bash-5.2# pg_createcluster
bash: pg_createcluster: command not found
bash-5.2# pg_ctlcluster
bash: pg_ctlcluster: command not found
bash-5.2# pg_dropcluster
bash: pg_dropcluster: command not found
bash-5.2# pg_lsclusters
bash: pg_lsclusters: command not found
bash-5.2# pg_renamecluster
bash: pg_renamecluster: command not found
bash-5.2# pg_backupcluster
bash: pg_backupcluster: command not found
bash-5.2# pg_restorecluster
bash: pg_restorecluster: command not found
bash-5.2# pg_upgradecluster
bash: pg_upgradecluster: command not found
bash-5.2# pg_virtualenv
bash: pg_virtualenv: command not found
bash-5.2# debconf-copydb
bash: debconf-copydb: command not found
bash-5.2# pg_updatedicts
bash: pg_updatedicts: command not found
bash-5.2# pg_rewind
bash: pg_rewind: command not found
bash-5.2# pg_controldata
bash: pg_controldata: command not found
bash-5.2# pg_upgrade
bash: pg_upgrade: command not found
bash-5.2# pg_test_fsync
bash: pg_test_fsync: command not found
bash-5.2# pg_checksums
bash: pg_checksums: command not found
bash-5.2# pg_resetwal
bash: pg_resetwal: command not found
bash-5.2# pg_waldump
bash: pg_waldump: command not found

Additional information

I think it's coverage error as well as RF error.

Vandit1604 avatar May 20 '24 08:05 Vandit1604