1 name: 'Setup Postgresql and Postgis'
7 - name: Install postgis
8 run: sudo apt-get install -y -qq postgresql-13-postgis-3 postgresql-13-postgis-3-scripts postgresql-server-dev-13
11 - name: Adapt postgresql configuration
13 echo 'fsync = off' | sudo tee /etc/postgresql/13/main/conf.d/local.conf
14 echo 'synchronous_commit = off' | sudo tee -a /etc/postgresql/13/main/conf.d/local.conf
15 echo 'full_page_writes = off' | sudo tee -a /etc/postgresql/13/main/conf.d/local.conf
18 - name: Setup database
20 sudo systemctl start postgresql
21 sudo -u postgres createuser -S www-data
22 sudo -u postgres createuser -s runner