| # postgres for talk-to-data(DWH - Data Warehouse for execute queries) | |
| # TODO: import initial data from csv files | |
| services: | |
| postgres: | |
| container_name: postgres | |
| image: postgres | |
| environment: | |
| POSTGRES_USER: postgres | |
| POSTGRES_PASSWORD: postgres | |
| POSTGRES_DB: datawarehouse | |
| PGDATA: /data/postgres | |
| volumes: | |
| - postgres:/data/postgres | |
| ports: | |
| - "5432:5432" | |
| restart: unless-stopped | |
| pgadmin: | |
| container_name: pgadmin | |
| image: dpage/pgadmin4 | |
| environment: | |
| PGADMIN_DEFAULT_EMAIL: admin@postgres.com | |
| PGADMIN_DEFAULT_PASSWORD: admin | |
| PGADMIN_CONFIG_SERVER_MODE: "False" | |
| PGADMIN_CONFIG_MASTER_PASSWORD_REQUIRED: "False" | |
| volumes: | |
| - pgadmin:/var/lib/pgadmin | |
| ports: | |
| - "5433:80" | |
| entrypoint: | |
| - "/bin/sh" | |
| - "-c" | |
| - "/bin/echo 'postgres:5432:*:postgres:password' > /tmp/pgpassfile && chmod 600 /tmp/pgpassfile && /entrypoint.sh" | |
| restart: unless-stopped | |
| volumes: | |
| postgres: | |
| pgadmin: |