Upgrade CI to check latest postgres/postgis matrices #102

	name: Run tests

	on:
	push:
	branches:
	- master
	tags:
	- '*'
	pull_request:
	branches:
	- master

	release:
	types: ['prereleased', 'released']


	jobs:

	run-tests:
	runs-on: ubuntu-latest

	strategy:
	fail-fast: false
	matrix:
	postgis:
	- postgresql-12-postgis-3
	- postgresql-15-postgis-3
	- postgresql-16-postgis-3
	env:
	PGSERVICEFILE: ${{github.workspace}}/tests/pg_service.conf
	POSTGRES_DB: qwat_test
	POSTGRES_PASSWORD: postgres
	PGHOST: 127.0.0.1
	PGPORT: 5432
	PGOPTIONS: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5

	steps:

	- uses: actions/checkout@v4

	- name: Install PostgreSQL postgis client
	run: \|
	sudo apt update
	sudo apt -y upgrade
	sudo apt -y install postgis ${{ matrix.postgis }}

	- name: Set up Python 3.12
	uses: actions/setup-python@v5
	with:
	python-version: 3.12

	- name: Install Python dependencies
	run: pip install -r requirements.txt

	- name: Run tests
	run: tests/tests.sh

	- name: Run scalability tests
	run: tests/tests_scalability.sh -i 20

	- name: Run scalability tests multithreaded
	run: tests/tests_scalability_multithread.sh -i 20

	- name: Run upgrade tests
	run: tests/tests_upgrade.sh

Provide feedback