Enable Postgres store tests #970

	name: CI
	on:
	pull_request:
	paths-ignore:
	- '.github/**' # Skip this workflow if the only change was inside the .github folder
	workflow_call:
	workflow_dispatch:


	jobs:
	# lint:
	# runs-on: ubuntu-20.04
	# continue-on-error: true
	# steps:
	# - uses: actions/checkout@v3
	# - uses: actions/setup-go@v4
	# with:
	# go-version-file: 'go.mod'
	# - name: golangci-lint
	# uses: golangci/golangci-lint-action@v3
	# with:
	# # Optional: version of golangci-lint to use in form of v1.2 or v1.2.3 or `latest` to use the latest version
	# version: latest
	# skip-pkg-cache: true
	# skip-build-cache: true

	build_test:
	name: Build and Test
	runs-on: ubuntu-20.04
	steps:
	- uses: actions/checkout@v3
	- uses: actions/setup-go@v4
	with:
	go-version-file: 'go.mod'
	- name: Install dependencies
	run: sudo apt-get update -y && sudo apt-get install -y gcc git-core gnupg build-essential
	- name: Remove installed mongodb
	run: sudo apt purge mongodb-org && sudo apt autoremove
	- run: sudo snap install juju-db --channel 4.4/stable
	- name: Add volume files
	run: \|
	touch ./local/vault/approle.json
	touch ./local/vault/roleid.txt
	- name: Start test environment
	run: docker compose up -d
	- name: Build and Test
	run: go test -mod readonly ./...
	env:
	JIMM_DSN: postgresql://jimm:jimm@localhost:5432/jimm
	JIMM_TEST_PGXDSN: postgresql://jimm:jimm@localhost:5432/jimm
	PGHOST: localhost
	PGPASSWORD: jimm
	PGSSLMODE: disable
	PGUSER: jimm
	PGPORT: 5432

Provide feedback