Task #1580
open
New testing environment - PostgreSQL
Added by Petr Fišer about 5 years ago.
Updated almost 5 years ago.
Description
Create / use some sensible PGSQL docker image.
This image will then be used as a base image for:
- czechidm repository
- end system (db table on postgres)
Task: primary task is to crete postgres docker image (with compose file) to server as repository for the CzechIdM.
Docker images from https://hub.docker.com/_/postgres are usable, managed to spin up an v11 postgres instance.
Also no need to clone the git if we are not planning on making changes. This compose works well, although it will need a little bit of tweaking (the volume is created with polkitd:root ownership on the host).
version: '2.1'
services:
database:
image: postgres:latest
environment:
- "POSTGRES_PASSWORD=demodemo"
volumes:
- "./data:/var/lib/postgresql/data"
ports:
- "5432:5432"
restart: always
developing postgres docker image
- % Done changed from 0 to 90
docker was image prepared
maybe some tuning will be needed when application image is done
version: '3'
services:
postgresidm:
image: nexus.bcvsolutions.eu:8445/postgresimage:v1
container_name: postgresidmcont
volumes:
- /etc/timezone:/etc/timezone:ro
- /etc/localtime:/etc/localtime:ro
ports:
- 5432:5432
environment:
- INIT_DBNAME=czechidm
- INIT_DBUSERNAME=czechidm
- INIT_DBUSERPASSWORD=xxxxxxx
#in kilobytes!!!!, total memory according to https://pgtune.leopard.in.ua
- DB_MEMORY_KB=2000000
hostname: postgresidm
- Status changed from New to In Progress
- Assignee set to Jan Kolařík
Also available in: Atom
PDF
