Postgres Versions Tests #15

	name: Postgres Versions Tests

	on:
	schedule:
	- cron: '0 18 * * 1'

	jobs:
	postgres:
	name: Python postgres unit tests
	runs-on: ubuntu-latest
	strategy:
	max-parallel: 5
	matrix:
	postgres-version: [9, 10, 11, 12, 13]
	services:
	# Label used to access the service container
	postgres:
	# Docker Hub image
	image: postgres:${{ matrix.postgres-version }}
	# Provide the password for postgres
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_DB: test
	# Set health checks to wait until postgres has started
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	# Maps tcp port 5432 on service container to the host
	- 5432:5432
	steps:
	- uses: actions/checkout@v4
	- name: Set up Python 3.9 for Postgres
	uses: actions/setup-python@v5
	with:
	python-version: 3.9
	- name: Install tox
	run: \|
	python -m pip install --upgrade pip
	pip install tox
	- name: tox env cache
	uses: actions/cache@v4
	with:
	path: ${{ github.workspace }}/.tox/py3.9
	key: ${{ runner.os }}-tox-py3.9-${{ hashFiles('requirements/*.txt') }}
	- name: Test with tox
	run: tox -e postgres

Provide feedback