-
Notifications
You must be signed in to change notification settings - Fork 7
123 lines (111 loc) · 3.99 KB
/
database.yml
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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
name: CI/CD database docker image
on:
push:
paths:
- ".github/workflows/database.yml"
- "infra/docker/database/*"
jobs:
build-database-image:
name: Build database image
runs-on: ubuntu-22.04
strategy:
matrix:
include:
- pg_major: "11"
timescaledb_version: "1.7.4"
postgis_version: "2.5.5"
dockerfile: "pg11.Dockerfile"
image_version: "pg11-ts1.7.4-postgis2.5.5"
- pg_major: "11"
timescaledb_version: "2.3.1"
postgis_version: "3.3.4"
dockerfile: "pg11.Dockerfile"
image_version: "pg11-ts2.3.1-postgis3.3.4"
- pg_major: "13"
timescaledb_version: "2.14.2"
postgis_version: "3.4.2"
dockerfile: "pg13_16.Dockerfile"
image_version: "pg13-ts2.14.2-postgis3.4.2"
- pg_major: "16"
timescaledb_version: "2.14.2"
postgis_version: "3.4.2"
dockerfile: "pg13_16.Dockerfile"
image_version: "pg16-ts2.14.2-postgis3.4.2"
permissions:
contents: read
packages: write
steps:
- name: Checkout
uses: actions/checkout@v4
- name: Set IMAGE_TAG
run: echo "IMAGE_TAG=ghcr.io/mtes-mct/monitorfish/monitorfish-database:${{ matrix.image_version }}" >> $GITHUB_ENV
- name: Set up Docker Buildx
id: buildx
uses: docker/setup-buildx-action@master
- name: Build image
uses: docker/build-push-action@v6
with:
context: .
load: true
builder: ${{ steps.buildx.outputs.name }}
file: infra/docker/database/${{ matrix.dockerfile }}
push: false
tags: ${{ env.IMAGE_TAG }}
build-args: |
PG_MAJOR=${{ matrix.pg_major }}
TIMESCALEDB_VERSION=${{ matrix.timescaledb_version }}
POSTGIS_VERSION=${{ matrix.postgis_version }}
- name: Push docker image to registry
run: |
echo "${{ secrets.GITHUB_TOKEN }}" | docker login ghcr.io -u ${GITHUB_ACTOR} --password-stdin
docker push ${{ env.IMAGE_TAG }}
build-database-upgrade-image:
name: Build database upgrade image
runs-on: ubuntu-22.04
strategy:
matrix:
include:
- distribution: "buster"
from_pg_major: "11"
to_pg_major: "13"
timescaledb_version: "2.3.1"
postgis_version: "3.3.4"
dockerfile: "upgrade_pg.Dockerfile"
image_version: "pg11_to_pg13-ts2.3.1-postgis3.3.4"
- distribution: "bookworm"
from_pg_major: "13"
to_pg_major: "16"
timescaledb_version: "2.14.2"
postgis_version: "3.4.2"
dockerfile: "upgrade_pg.Dockerfile"
image_version: "pg13_to_pg16-ts2.14.2-postgis3.4.2"
permissions:
contents: read
packages: write
steps:
- name: Checkout
uses: actions/checkout@v4
- name: Set IMAGE_TAG
run: echo "IMAGE_TAG=ghcr.io/mtes-mct/monitorfish/monitorfish-database-upgrade:${{ matrix.image_version }}" >> $GITHUB_ENV
- name: Set up Docker Buildx
id: buildx
uses: docker/setup-buildx-action@master
- name: Build image
uses: docker/build-push-action@v6
with:
context: .
load: true
builder: ${{ steps.buildx.outputs.name }}
file: infra/docker/database/${{ matrix.dockerfile }}
push: false
tags: ${{ env.IMAGE_TAG }}
build-args: |
DISTRIBUTION=${{ matrix.distribution }}
FROM_PG_MAJOR=${{ matrix.from_pg_major }}
TO_PG_MAJOR=${{ matrix.to_pg_major }}
TIMESCALEDB_VERSION=${{ matrix.timescaledb_version }}
POSTGIS_VERSION=${{ matrix.postgis_version }}
- name: Push docker image to registry
run: |
echo "${{ secrets.GITHUB_TOKEN }}" | docker login ghcr.io -u ${GITHUB_ACTOR} --password-stdin
docker push ${{ env.IMAGE_TAG }}