postgresql Docker container service for Gearbox
This is the repository for the postgresql Docker container implemented for Gearbox.
GitHub commit:
GitHub release(latest): 
| Service | GitHub Version | Docker Version | Docker Size | Docker Tags |
|---|---|---|---|---|
| postgresql |  |
 |
 |
(10.12, 10) |
| postgresql |  |
 |
 |
(11.7, 11) |
| postgresql |  |
 |
 |
(12.2, 12, latest) |
| postgresql |  |
 |
 |
(9.4.26, 9.4) |
| postgresql |  |
 |
 |
(9.5.21, 9.5) |
| postgresql |  |
 |
 |
(9.6.17, 9.6) |
A driving force behind Gearbox is to improve the user experience using software, and especially for software developers.
Our vision is to empower developers and other software users to quickly and easily use almost any version of a software service, command line tool or API without without first getting bogged down with installation and configuration.
In other words, our vision for Gearbox users is that software "just works".
This container has been designed to work within the Gearbox framework. However, due to the flexability of Gearbox, it can be used outside of this framework.
There are three methods:
launch is a tool specifically designed to interact with a Gearbox Docker container.
It provides three important functional areas, without any Docker container learning curve:
- Allows control over Gearbox Docker containers: stop, start, create, remove.
- Build, update, modify and release Docker images.
- Acts as a proxy for interactive commands within a Gearbox Docker container.
It also provides a functional SSH daemon for connecting remotely as well as a standard set of common tools and utilities.
Further launch documentation can be found here.
launch is currently in beta testing and is included along with all Gearbox Docker repos.
Once out of beta, it will be included within the Gearbox installation package.
For now, simply download the standalone launch binary for your O/S.
There are many ways to call launch, either directly or indirectly. Additionally, all host environment variables will be imported into the container seamlessly. This allows a devloper to try multiple versions of software as though they were installed locally.
If a container is missing, it will be downloaded and created. Multiple versions can co-exist.
Install, create, and start the postgresql Gearbox container.
./launch install postgresql
Create, and start the postgresql Gearbox container. Run a shell.
./launch shell postgresql
Create, and start the postgresql Gearbox container with version 9.5.21 and run a shell.
./launch shell postgresql:9.5.21
./launch shell postgresql:9.5.21 ls -l
./launch shell postgresql:9.5.21 ps -eaf
If postgresql is symlinked to launch, then the Gearbox container will be determined automatically and the default command will be run.
All available commands for a Gearbox container will be automatically symlinked upon installation.
./postgresql
Running postgresql Gearbox container default command. If a container has a default interactive command, arguments can be supplied without specifying that command.
./postgresql -flag1 -flag2 variable
./launch postgresql:9.5.21 -flag1 -flag2 variable
Gearbox containers may have multiple executables that can be run. The postgresql Gearbox container has the following available commands:
clusterdb- will execute/usr/local/bin/clusterdbwithin the container.createdb- will execute/usr/local/bin/createdbwithin the container.createlang- will execute/usr/local/bin/createlangwithin the container.createuser- will execute/usr/local/bin/createuserwithin the container.- The default command will execute
/usr/local/bin/psqlwithin the container. dropdb- will execute/usr/local/bin/dropdbwithin the container.droplang- will execute/usr/local/bin/droplangwithin the container.dropuser- will execute/usr/local/bin/dropuserwithin the container.ecpg- will execute/usr/local/bin/ecpgwithin the container.initdb- will execute/usr/local/bin/initdbwithin the container.pg_archivecleanup- will execute/usr/local/bin/pg_archivecleanupwithin the container.pg_basebackup- will execute/usr/local/bin/pg_basebackupwithin the container.pg_config- will execute/usr/local/bin/pg_configwithin the container.pg_controldata- will execute/usr/local/bin/pg_controldatawithin the container.pg_ctl- will execute/usr/local/bin/pg_ctlwithin the container.pg_dump- will execute/usr/local/bin/pg_dumpwithin the container.pg_dumpall- will execute/usr/local/bin/pg_dumpallwithin the container.pg_isready- will execute/usr/local/bin/pg_isreadywithin the container.pg_receivexlog- will execute/usr/local/bin/pg_receivexlogwithin the container.pg_recvlogical- will execute/usr/local/bin/pg_recvlogicalwithin the container.pg_resetxlog- will execute/usr/local/bin/pg_resetxlogwithin the container.pg_restore- will execute/usr/local/bin/pg_restorewithin the container.pg_standby- will execute/usr/local/bin/pg_standbywithin the container.pg_test_fsync- will execute/usr/local/bin/pg_test_fsyncwithin the container.pg_test_timing- will execute/usr/local/bin/pg_test_timingwithin the container.pg_upgrade- will execute/usr/local/bin/pg_upgradewithin the container.pg_xlogdump- will execute/usr/local/bin/pg_xlogdumpwithin the container.pgbench- will execute/usr/local/bin/pgbenchwithin the container.postmaster- will execute/usr/local/bin/postmasterwithin the container.psql- will execute/usr/local/bin/psqlwithin the container.reindexdb- will execute/usr/local/bin/reindexdbwithin the container.vacuumdb- will execute/usr/local/bin/vacuumdbwithin the container.vacuumlo- will execute/usr/local/bin/vacuumlowithin the container.
ssh - All Gearbox containers have a running SSH daemon. So you can connect remotely. To show what ports are exported to the host, use the following command.
./launch list postgresql
Simply clone this repository to your local machine
git clone https://github.com/gearboxworks/docker-postgresql.git
make build - Build Docker images. Build all versions from the base directory or specific versions from each directory.
make list - List already built Docker images. List all versions from the base directory or specific versions from each directory.
make clean - Remove already built Docker images. Remove all versions from the base directory or specific versions from each directory.
make push - Push already built Docker images to Docker Hub, (only for Gearbox admins). Push all versions from the base directory or specific versions from each directory.
You can either build your container as above, or use it from DockerHub with these commands:
make start - Spin up a Docker container with the correct runtime configs.
make stop - Stop a Docker container.
make run - Run a Docker container in the foreground, (all STDOUT and STDERR will go to console). The Container be removed on termination.
make shell - Run a shell, (/bin/bash), within a Docker container.
make rm - Remove the Docker container.
make test - Will issue a stop, rm, clean, build, create and start on a Docker container.
A simple docker pull gearbox/postgresql will pull down the latest version.
start - Spin up a Docker container with the correct runtime configs.
docker run -d --name postgresql-latest --restart unless-stopped --network gearboxnet gearbox/postgresql:latest
stop - Stop a Docker container.
docker stop postgresql-latest
rm - Remove the Docker container.
docker container rm postgresql-latest
run - Run a Docker container in the foreground, (all STDOUT and STDERR will go to console). The Container be removed on termination.
docker run --rm --name postgresql-latest --network gearboxnet gearbox/postgresql:latest
shell - Run a shell, (/bin/bash), within a Docker container.
docker run --rm --name postgresql-latest -i -t --network gearboxnet gearbox/postgresql:latest /bin/bash
ssh - All Gearbox containers have a running SSH daemon. So you can connect remotely.
Either use launch above or discover the port and SSH directly.
SSH_PORT="$(docker port postgresql-latest 22/tcp | sed 's/0.0.0.0://')"
ssh -p ${SSH_PORT} -o StrictHostKeyChecking=no gearbox@localhost