66 lines
1.4 KiB
YAML
66 lines
1.4 KiB
YAML
services:
|
|
postgres:
|
|
image: docker.io/postgres:14
|
|
container_name: postgres
|
|
restart: unless-stopped
|
|
ports:
|
|
- target: 5432
|
|
published: 5432
|
|
mode: host
|
|
volumes:
|
|
# - /home/marc/backup:/backup
|
|
- /srv/postgres:/var/lib/postgresql/data
|
|
- ../../data/postgres/initdb.d:/initdb.d
|
|
- ../../data/postgres/certs:/var/lib/postgresql/certs
|
|
env_file: .env
|
|
command: 'postgres
|
|
|
|
-c log_statement=all
|
|
|
|
-c log_destination=stderr
|
|
|
|
'
|
|
networks:
|
|
- postgres
|
|
healthcheck:
|
|
test:
|
|
- CMD-SHELL
|
|
- pg_isready -q || exit 1
|
|
interval: 10s
|
|
timeout: 3s
|
|
retries: 3
|
|
|
|
pgagent:
|
|
image: docker.io/chiavegatto/postgres-pgagent
|
|
entrypoint: /bin/sh -c "/tmp/wait-for-it.sh postgres:5432 --timeout=30 && psql
|
|
-U postgres -h postgres -p 5432 -d postgres -c 'CREATE EXTENSION IF NOT EXISTS
|
|
pgagent;' && pgagent -f hostaddr=postgres dbname=postgres user=postgres port=5432"
|
|
environment:
|
|
TIMEZONE: Europe/Paris
|
|
env_file: .env
|
|
networks:
|
|
- postgres
|
|
|
|
backup:
|
|
image: docker.io/kartoza/pg-backup:14-3.1
|
|
env_file: .env
|
|
networks:
|
|
- postgres
|
|
volumes:
|
|
- /srv/pg-backup:/backups
|
|
|
|
pgbackups:
|
|
image: docker.io/prodrigestivill/postgres-backup-local
|
|
restart: unless-stopped
|
|
volumes:
|
|
- /srv/pgbackups:/backups
|
|
networks:
|
|
- postgres
|
|
env_file: .env
|
|
|
|
volumes:
|
|
postgres: null
|
|
networks:
|
|
postgres:
|
|
external: true
|