]> git.openstreetmap.org Git - nominatim.git/blob - .github/actions/setup-postgresql/action.yml
actions: run tests also on postgresql 9.5
[nominatim.git] / .github / actions / setup-postgresql / action.yml
1 name: 'Setup Postgresql and Postgis'
2
3 inputs:
4     postgresql-version:
5         description: 'Version of PostgreSQL to install'
6         required: true
7     postgis-version:
8         description: 'Version of Postgis to install'
9         required: true
10
11 runs:
12     using: "composite"
13
14     steps:
15         - name: Remove existing PostgreSQL
16           run: |
17               sudo apt-get update -qq
18               sudo apt-get purge -yq postgresql*
19           shell: bash
20
21         - name: Install PostgreSQL
22           run: |
23               sudo apt-get install -y -qq --no-install-suggests --no-install-recommends postgresql-client-${PGVER} postgresql-${PGVER}-postgis-${POSTGISVER} postgresql-${PGVER}-postgis-${POSTGISVER}-scripts postgresql-contrib-${PGVER} postgresql-${PGVER} postgresql-server-dev-${PGVER}
24           shell: bash
25           env:
26               PGVER: ${{ inputs.postgresql-version }}
27               POSTGISVER: ${{ inputs.postgis-version }}
28
29         - name: Adapt postgresql configuration
30           run: |
31               echo 'fsync = off' | sudo tee /etc/postgresql/${PGVER}/main/conf.d/local.conf
32               echo 'synchronous_commit = off' | sudo tee -a /etc/postgresql/${PGVER}/main/conf.d/local.conf
33               echo 'full_page_writes = off' | sudo tee -a /etc/postgresql/${PGVER}/main/conf.d/local.conf
34               echo 'shared_buffers = 1GB' | sudo tee -a /etc/postgresql/${PGVER}/main/conf.d/local.conf
35               echo 'port = 5432' | sudo tee -a /etc/postgresql/${PGVER}/main/conf.d/local.conf
36           shell: bash
37           env:
38               PGVER: ${{ inputs.postgresql-version }}
39
40         - name: Setup database
41           run: |
42               sudo systemctl restart postgresql
43               sudo -u postgres createuser -S www-data
44               sudo -u postgres createuser -s runner
45           shell: bash