postgres_docker/docker-compose.yml at main · alphakatorz/postgres_docker · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
version: '3.7'

services:

 # postgreSQL service (share data between services)

 postgres_dwh:
   image: postgres:latest
   volumes:
     - ./data:/var/lib/postgresql/data
   container_name: postgres_dwh
   ports:
     - "5433:5432"
   environment:
     POSTGRES_USER: $DWH_POSTGRES_ADMIN
     POSTGRES_PASSWORD: $DWH_POSTGRES_PASSWORD
     POSTGRES_DB: $DWH_POSTGRES_DATABASE

 pgadmin:
   container_name: pgadmin
   image: dpage/pgadmin4
   environment:
     - PGADMIN_DEFAULT_EMAIL=test@jaimal.com
     - PGADMIN_DEFAULT_PASSWORD=pass4pgadmin
     - PGADMIN_CONFIG_SERVER_MODE=False
   volumes:
     - ./queries:/home/queries
   ports:
     - 5050:80
  dbt:
   image: datafuel/dbt
   # build: ./dbt_repo
   # command: python -u metabase_setup.py
   container_name: dbt
   expose:
     - 4444
   ports:
     - 4444:4444
   volumes:
     - ./dbt_repo/src:/src
     - ./dbt_repo/profiles:/root/.dbt
     - ./dbt_repo/metabt:/src_metabt/metabt
   environment:
     DWH_POSTGRES_ADMIN: $DWH_POSTGRES_ADMIN
     DWH_POSTGRES_PASSWORD: $DWH_POSTGRES_PASSWORD
     DWH_POSTGRES_DB: $DWH_POSTGRES_DATABASE
     DWH_POSTGRES_HOST: postgres_dwh
     MB_ADMIN_EMAIL: $MB_ADMIN_EMAIL
     MB_ADMIN_PASSWORD: $MB_ADMIN_PASSWORD
     DWH_POSTGRES_PORT: 5432
     DWH_POSTGRES_STG_SCHEMA: stg
     DWH_POSTGRES_PRS_SCHEMA: prs
     MB_ADMIN_FIRST_NAME: $MB_ADMIN_FIRST_NAME
     MB_ADMIN_LAST_NAME: $MB_ADMIN_LAST_NAME
   stdin_open: true
   tty: true

networks:
   default:
       external:
           name: datafuel-local-network