CircleCI便捷镜像,集成PostgreSQL数据库,用于CI/CD流程中快速部署和运行PostgreSQL相关的测试及开发任务,简化配置。
</p> <h1>CircleCI Convenience Images => PostgreSQL</h1> <h3>A Continuous Integration focused PostgreSQL Docker image built to run on CircleCI</h3>
This image is designed to supercede the legacy CircleCI PostgreSQL image, circleci/postgres.
cimg/postgres is a Docker image created by CircleCI with continuous integration builds in mind.
Table of Contents
- Getting Started
- How This Image Works
- Development
- Contributing
- Additional Resources
- License
Getting Started
This image can be used with the CircleCI docker executor as a secondary image.
For example:
yamljobs: build: docker: - image: cimg/go:1.17 - image: cimg/postgres:13.2 steps: - checkout
In the above example, the CircleCI Go Docker image is used for the primary container while the PostgreSQL image is used as a secondary.
More specifically, the tag 13.2 is used meaning the version of PostgreSQL will be v13.2.
You can now connect to a PostgreSQL instance from the primary image within the steps for this job.
How This Image Works
This image contains the PostgreSQL database and its complete toolchain.
Variants
Variant images typically contain the same base software, but with a few additional modifications.
PostGIS
The PostGIS variant is the same PostgreSQL image but with PostGIS (and its several dependencies) pre-installed.
The PostGIS variant can be used by appending -postgis to the end of an existing cimg/postgres tag.
yamljobs: build: docker: - image: cimg/go:1.17 - image: cimg/postgres:13.1-postgis steps: - checkout - run: echo "Do things"
RAM
The legacy version of this image, circleci/postgres had a RAM variant.
This is no longer the case.
We're determining how much of a performance increase does this variant actually give before we decide to bring it back.
If you used the legacy PostgreSQL image and you have data on the ram vs non-ram variant build times, please open a GitHub Issue and let us know.
Tagging Scheme
This image has the following tagging scheme:
cimg/postgres:<pg-version>
<pg-version> - The version of PostgreSQL to use.
Development
Images can be built and run locally with this repository. This has the following requirements:
- local machine of Linux (Ubuntu tested) or macOS
- modern version of Bash (v4+)
- modern version of Docker Engine (v19.03+)
Cloning For Community Users (no write access to this repository)
Fork this repository on GitHub.
When you get your clone URL, you'll want to add --recurse-submodules to the clone command in order to populate the Git submodule contained in this repo.
It would look something like this:
bashgit clone --recurse-submodules <my-clone-url>
If you missed this step and already cloned, you can just run git submodule update --recursive to populate the submodule.
Then you can optionally add this repo as an upstream to your own:
bashgit remote add upstream https://github.com/CircleCI-Public/cimg-postgres.git
Cloning For Maintainers ( you have write access to this repository)
Clone the project with the following command so that you populate the submodule:
bashgit clone --recurse-submodules git@github.com:CircleCI-Public/cimg-postgres.git
Generating Dockerfiles
Dockerfiles can be generated for a specific PostgreSQL version using the gen-dockerfiles.sh script.
For example, to generate the Dockerfile for v13.2, you would run the following from the root of the repo:
bash./shared/gen-dockerfiles.sh 13.2
The generated Dockerfile will be located at ./13.2/Dockefile.
To build this image locally and try it out, you can run the following:
bashcd 13.2 docker build -t test/postgres:13.2 . docker run -it test/postgres:13.2 bash
Building the Dockerfiles
To build the Docker images locally as this repository does, you'll want to run the build-images.sh script:
bash./build-images.sh
This would need to be run after generating the Dockerfiles first. When releasing proper images for CircleCI, this script is run from a CircleCI pipeline and not locally.
Publishing Official Images (for Maintainers only)
The individual scripts (above) can be used to create the correct files for an image, and then added to a new git branch, committed, etc. A release script is included to make this process easier. To make a proper release for this image, let's use the fake PostgreSQL version of v9.99, you would run the following from the repo root:
bash./shared/release.sh 9.99
This will automatically create a new Git branch, generate the Dockerfile(s), stage the changes, commit them, and push them to GitHub.
The commit message will end with the string [release].
This string is used by CircleCI to know when to push images to Docker Hub.
All that would need to be done after that is:
- wait for build to pass on CircleCI
- review the PR
- merge the PR
The main branch build will then publish a release.
Incorporating Changes
How changes are incorporated into this image depends on where they come from.
build scripts - Changes within the ./shared submodule happen in its https://github.com/CircleCI-Public/cimg-shared.
For those changes to affect this image, the submodule needs to be updated.
Typically like this:
bashcd shared git pull cd .. git add shared git commit -m "Updating submodule for foo."
parent image - By design, when changes happen to a parent image, they don't appear in existing PostgreSQL images. This is to aid in "determinism" and prevent breaking customer builds. New Go images will automatically pick up the changes.
If you really want to publish changes from a parent image into the PostgreSQL image, you have to build a specific image version as if it was a new image. This will create a new Dockerfile and once published, a new image.
PostgreSQL specific changes - Editing the Dockerfile.template file in this repo will modify the PostgreSQL image specifically.
Don't forget that to see any of these changes locally, the gen-dockerfiles.sh script will need to be run again (see above).
Contributing
We encourage https://github.com/CircleCI-Public/cimg-postgres/issues and https://github.com/CircleCI-Public/cimg-postgres/pulls against this repository. In order to value your time, here are some things to ***:
- We won't include just anything in this image. In order for us to add a tool within the PostgreSQL image, it has to be something that is maintained and useful to a large number of PostgreSQL users. Every tool added makes the image larger and slower for all users so being thorough on what goes in the image will benefit everyone.
- PRs are welcome. If you have a PR that will potentially take a large amount of time to make, it will be better to open an issue to discuss it first to make sure it's something worth investing the time in.
- Issues should be used to report bugs or request additional/removal of tools in this image. For help with images, please visit https://discuss.circleci.com/c/ecosystem/circleci-images.
Additional Resources
https://circleci.com/docs/ - The official CircleCI Documentation website.
https://circleci.com/docs/2.0/configuration-reference/#section=configuration - From CircleCI Docs, the configuration reference page is one of the most useful pages we have.
It will list all of the keys and values supported in .circleci/config.yml.
https://docs.docker.com/ - For simple projects this won't be needed but if you want to dive deeper into learning Docker, this is a great resource.
Credit
This repository uses upstream resources from the Docker library, specifically, the https://github.com/docker-library/postgres/blob/master/docker-entrypoint.sh
License
This repository is licensed under the MIT license. The license can be found here.
镜像拉取方式
您可以使用以下命令拉取该镜像。请将 <标签> 替换为具体的标签版本。如需查看所有可用标签版本,请访问 标签列表页面。
DockerHub 原生拉取命令
用户好评
来自真实用户的反馈,见证轩辕镜像的优质服务