Skip to content

Instantly share code, notes, and snippets.

@WorldException
Created August 5, 2021 07:22
Show Gist options
  • Save WorldException/54b585f2432e098c8b67d4d9253d7d71 to your computer and use it in GitHub Desktop.
Save WorldException/54b585f2432e098c8b67d4d9253d7d71 to your computer and use it in GitHub Desktop.
postgres for 1C docker
version: "2"
services:
db:
restart: always
#image: quickes/pg1c:12.6_6
image: quickes/pg1c:12.7_1
shm_size: 4G
stop_grace_period: 1m
stop_signal: SIGINT
oom_score_adj: -1000
environment:
- PG_PASSWORD=xxxxx
- TZ=Europe/Moscow
volumes:
- pg-data:/var/lib/postgresql
- pg-run:/run/postgresql
- ./dump:/dump
ports:
- 5432:5432
command: >
-c shared_buffers=2024MB
-c work_mem=512MB
-c maintenance_work_mem=1GB
-c temp_buffers=256MB
-c effective_cache_size=4GB
-c effective_io_concurrency=4
-c autovacuum=on
-c fsync=on
-c synchronous_commit=off
-c max_connections=100
-c max_wal_size=1GB
-c timezone=Europe/Moscow
-c idle_in_transaction_session_timeout=30min
-c logging_collector=off
-c commit-delay=1000
-c commit-siblings=10
-c max_files_per_process=8000
-c standard_conforming_strings=off
-c escape_string_warning=off
-c max_locks_per_transaction=256
-c row_security=off
pgadmin:
restart: always
image: dpage/pgadmin4:latest
ports:
- 5544:80
links:
- db:db
depends_on:
- db
environment:
- [email protected]
- PGADMIN_DEFAULT_PASSWORD=xxxxx
- TZ=Europe/Moscow
volumes:
- pg-admin:/var/lib/pgadmin
volumes:
pg-data:
pg-run:
pg-admin:
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment