pgmigrate/example/docker-compose.yml at main · geckoboard/pgmigrate · 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
version: "3.6"
services:
  appdb:
    image: postgres:17
    environment:
      POSTGRES_USER: appuser
      POSTGRES_DB: exampleapp
      POSTGRES_PASSWORD: verysecret
    restart: unless-stopped
    ports:
      - "5435:5432"
  testdb:
    image: postgres:17
    environment:
      POSTGRES_USER: appuser
      POSTGRES_DB: testdb
      POSTGRES_PASSWORD: verysecret
    restart: unless-stopped
    # Uses a tmpfs volume to make tests extremely fast. The data in test
    # databases is not persisted across restarts, nor does it need to be.
    volumes:
      - type: tmpfs
        target: /var/lib/postgresql/data/
    # Turns off all data validity checks for even more speed. This will work
    # fine in CI and testing.
    command:
      - "postgres"
      - "-c"
      - "fsync=off"
      - "-c"
      - "shared_buffers=1024MB"
      - "-c"
      - "synchronous_commit=off"
      - "-c"
      - "full_page_writes=off"
      - "-c"
      - "log_statement=all"
      - "-c"
      - "max_connections=1000"
    ports:
      - "5436:5432"