Skip to content

Merge pull request #51 from kartoza/presentation-style #8

Merge pull request #51 from kartoza/presentation-style

Merge pull request #51 from kartoza/presentation-style #8

Workflow file for this run

name: 🏋🏽 PostGIS Load Test
on:
push:
paths:
- '**'
# - 'sql/**.sql'
# - '.github/workflows/sql-lint-and-load.yml'
# - 'load_schema.sh'
pull_request:
paths:
- 'sql/**.sql'
- '.github/workflows/sql-lint-and-load.yml'
- 'load_schema.sh'
workflow_dispatch:
jobs:
postgis-load:
runs-on: ubuntu-latest
services:
postgres:
image: postgis/postgis:16-3.4
env:
POSTGRES_USER: postgres
POSTGRES_PASSWORD: postgres
POSTGRES_DB: gis
ports:
- 5432:5432
options: >-
--health-cmd="pg_isready -U postgres" --health-interval=10s --health-timeout=5s --health-retries=5
steps:
- name: Checkout repository
uses: actions/checkout@v4
- name: Wait for Postgres to be ready
run: |
for _ in {1..30}; do
pg_isready -h localhost -U postgres && break
sleep 2
done
- name: Install PostgreSQL client
run: sudo apt-get update && sudo apt-get install -y postgresql-client
- name: Run load_schema.sh
env:
PGHOST: localhost
PGUSER: postgres
PGPASSWORD: postgres
PGDATABASE: gis
PGPORT: 5432
run: |
chmod +x ./scripts/load_schema.sh
./scripts/load_schema.sh