jfxs/postgres-client repository overview

⁠Docker Postgres client

A Postgres client⁠ Docker image:

• lightweight image based on Alpine Linux only 6 MB,
• multiarch with support of amd64 and arm64,
• non-root container user,
• automatically updated by comparing software bill of materials (SBOM) changes,
• image signed with Cosign⁠,
• a software bill of materials (SBOM) attestation added using Syft⁠,
• available on Docker Hub and Quay.io.

The main repository.

The Docker Hub registry.

The Quay.io registry.

⁠Running task

docker run -t --rm jfxs/postgres-client task --version

or

docker run -t --rm quay.io/ifxs/postgres-client task --version

⁠Built with

Docker latest tag is 16.14.0-004, 16.14, 16⁠ and contains:

Details are updated on Dockerhub Overview page⁠ when an image is published.

⁠Versioning

Docker tag definition:

• the Postgres client psql version used,
• a dash
• an increment to differentiate build with the same version starting at 001

<psql_version>-<increment>

Example: 16.3.0-001

⁠Signature and attestation

Cosign⁠ public key:

-----BEGIN PUBLIC KEY-----
MFkwEwYHKoZIzj0CAQYIKoZIzj0DAQcDQgAEa3yV6+yd/l4zh/tfT6Tx+zn0dhy3
BhFqSad1norLeKSCN2MILv4fZ9GA6ODOlJOw+7vzUvzZVr9IXnxEdjoWJw==
-----END PUBLIC KEY-----

The public key is also available online: https://gitlab.com/op_so/docker/cosign-public-key/-/raw/main/cosign.pub⁠.

To verify an image:

cosign verify --key cosign.pub $IMAGE_URI

To verify and get the SBOM attestation:

cosign verify-attestation --key cosign.pub --type spdxjson $IMAGE_URI | jq '.payload | @base64d | fromjson | .predicate'

⁠Authors

• FX Soubirou - Initial work - GitLab repositories⁠

⁠License

This program is free software: you can redistribute it and/or modify it under the terms of the MIT License (MIT). See the LICENSE⁠ for details.