CI: postgres smoke test (#193) #16

	on: [ push, pull_request, workflow_dispatch ]

	permissions:
	contents: read

	jobs:
	Test:
	strategy:
	matrix:
	cc: [ gcc, clang ]
	fail-fast: false
	name: ${{ matrix.cc }}
	runs-on: ubuntu-24.04
	services:
	postgres:
	image: postgres
	env:
	POSTGRES_USER: test_user
	POSTGRES_PASSWORD: test_password
	POSTGRES_DB: test_db
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	- 5432:5432
	mariadb:
	image: mariadb:latest
	env:
	MYSQL_ROOT_PASSWORD: root_password
	MYSQL_DATABASE: test_db
	MYSQL_USER: test_user
	MYSQL_PASSWORD: test_password
	options: >-
	--health-cmd "healthcheck.sh --connect --innodb_initialized"
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	- 3306:3306
	steps:
	- uses: actions/checkout@v4
	- name: Install apt dependencies
	run: \|
	sudo apt-get update
	sudo apt-get install -y libltdl-dev odbc-mariadb odbc-postgresql
	- name: configure
	run: \|
	autoreconf -iv
	CC=${{ matrix.cc }} CFLAGS="-ggdb -fsanitize=address" ./configure --prefix=/usr
	- name: build
	run: \|
	##make AM_MAKEFLAGS=CFLAGS=-Werror
	make
	sudo make install
	- name: mariadb smoke test
	run: \|
	sudo -E ./exe/.libs/odbcinst -i -d -f .github/MariaDB_odbc_driver_template.ini
	./exe/.libs/odbcinst -i -s -h -f .github/MariaDB_odbc_data_source_template.ini
	echo 'SELECT VERSION();' \| ./exe/.libs/isql -v MariaDB-server -b
	- name: postgres smoke test
	run: \|
	./exe/.libs/odbcinst -i -s -h -f .github/postgres_odbc.ini
	echo 'SELECT VERSION();' \| ./exe/.libs/isql -v PostgreSQL-server -b

Provide feedback