Port fixes from master #540

	name: Build for macOS

	# manually triggered workflow
	# - macOS test takes too much time

	on:
	workflow_dispatch:
	push:
	paths:
	- '.github/workflows/macos.yml'
	- 'src/**'
	- 'include/**'
	- 'pgtap/**'
	- 'tools/testers/**'
	- './CMakeLists.txt'

	branches-ignore:
	- 'gh-pages'

	tags: []

	pull_request:
	paths:
	- '.github/workflows/macos.yml'
	- 'src/**'
	- 'include/**'
	- 'pgtap/**'
	- 'tools/testers/**'
	- './CMakeLists.txt'

	branches-ignore:
	- 'gh-pages'

	concurrency:
	group: ${{ github.workflow }}-${{ github.ref }}
	cancel-in-progress: true

	permissions:
	contents: read

	jobs:
	build:
	name: macos
	runs-on: ${{ matrix.os }}

	strategy:
	fail-fast: false
	matrix:
	os: [macos-latest, macos-14]

	steps:
	- name: Checkout repository
	uses: actions/checkout@v4

	- name: install deps
	run: \|
	brew install postgresql@14 postgis boost

	- name: Configure
	run: \|
	mkdir build
	cd build
	cmake -DCMAKE_BUILD_TYPE=Release -DWITH_DOC=OFF ..

	- name: Build
	run: \|
	cd build
	make -j
	make install

	- name: Install pgTAP
	run: \|
	git clone https://github.com/theory/pgtap.git pgTapExtension
	cd pgTapExtension
	make -j
	make install
	cpan TAP::Parser::SourceHandler::pgTAP
	ln -s $(find `brew --prefix` -name pg_prove) symlink it into $(brew --prefix)/bin

	- name: Test
	run: \|
	export PATH=$(brew --prefix)/Cellar/perl/$(perl -e 'print substr($^V, 1)')/bin:$PATH
	pg_ctl -D $(brew --prefix)/var/postgresql@14 start
	createuser -s postgres
	createdb ___pgr___test___
	bash ./tools/testers/pg_prove_tests.sh postgres 5432 Release

Provide feedback