Extended PostgreSQL Docker Image
Docker image for postgres
extended with management bash scripts.
Build images
To build the images and push them to the registry:
make build
make push
Docker-compose example
Example of a docker-compose.yml
file that uses this image:
version: '3'
volumes:
postgres_data: {}
postgres_backups: {}
services:
service:
image: service:latest
command: ./start
postgres:
image: marcosgabarda/postgres:latest
volumes:
- postgres_data:/var/lib/postgresql/data
- postgres_backups:/backups
env_file:
- ./.env
## Maintenance commands
This images adds commands to the original PostgreSQL image for maintenance proposes.
Create a database backup
Creates a backup of the database. Usage:
$ docker-compose -f <environment>.yml (exec |run --rm) postgres backup
View backups
Views a list of all created backups of the database. Usage:
$ docker-compose -f <environment>.yml (exec |run --rm) postgres backups
Creates a read only user
Creates a read only user. Usage:
$ docker-compose -f <environment>.yml (exec |run --rm) postgres createreaduser
Restore database from a backup
Restores the indicated database backup. Usage:
$ docker-compose -f <environment>.yml (exec |run --rm) postgres restore <1>
Parameters:
<1>
filename of an existing backup.