Add postgres version tests to github actions #4
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Test PostgreSQL Versions | |
| on: | |
| push: | |
| branches: [ master, main ] | |
| pull_request: | |
| branches: [ master, main ] | |
| jobs: | |
| test: | |
| runs-on: ubuntu-latest | |
| strategy: | |
| matrix: | |
| test-name: ['postgres-dba-tests'] | |
| fail-fast: false | |
| steps: | |
| - name: Checkout code | |
| uses: actions/checkout@v4 | |
| - name: Start PostgreSQL and configure | |
| run: | | |
| # Stop default PostgreSQL if running | |
| sudo systemctl stop postgresql.service || true | |
| # Find PostgreSQL config files | |
| echo "PostgreSQL config files:" | |
| find /etc/postgresql -name "postgresql.conf" -type f | |
| find /etc/postgresql -name "pg_hba.conf" -type f | |
| # Configure PostgreSQL for pg_stat_statements (multiple approaches to ensure it works) | |
| sudo sed -i "s/#shared_preload_libraries = ''/shared_preload_libraries = 'pg_stat_statements'/" /etc/postgresql/*/main/postgresql.conf || true | |
| sudo sed -i "s/^#shared_preload_libraries = ''/shared_preload_libraries = 'pg_stat_statements'/" /etc/postgresql/*/main/postgresql.conf || true | |
| sudo bash -c "echo \"shared_preload_libraries = 'pg_stat_statements'\" >> /etc/postgresql/*/main/postgresql.conf" | |
| # Show the final configuration | |
| echo "Final postgresql.conf shared_preload_libraries setting:" | |
| grep -n "shared_preload_libraries" /etc/postgresql/*/main/postgresql.conf || echo "Not found" | |
| # Set trust authentication for local connections | |
| sudo bash -c "echo 'local all all trust' > /etc/postgresql/*/main/pg_hba.conf" | |
| # Start PostgreSQL | |
| sudo systemctl start postgresql.service | |
| pg_isready | |
| # Create runner user and test database | |
| sudo -u postgres createuser -s runner | |
| sudo -u postgres createdb test | |
| - name: Prepare test database | |
| run: | | |
| # Check PostgreSQL version and available extensions | |
| sudo -u postgres psql -d test -c 'SELECT version();' | |
| sudo -u postgres psql -d test -c 'SELECT * FROM pg_available_extensions WHERE name IN ('"'"'pg_stat_statements'"'"', '"'"'pgstattuple'"'"');' | |
| # Create extensions (they need to be created by superuser) | |
| sudo -u postgres psql -d test -c 'CREATE EXTENSION IF NOT EXISTS pg_stat_statements;' | |
| sudo -u postgres psql -d test -c 'CREATE EXTENSION IF NOT EXISTS pgstattuple;' | |
| # Verify extensions are created | |
| sudo -u postgres psql -d test -c 'SELECT * FROM pg_extension;' | |
| # Create test tables | |
| psql -d test -c "CREATE TABLE align1 AS SELECT 1::int4, 2::int8, 3::int4 AS more FROM generate_series(1, 100000) _(i);" | |
| psql -d test -c "CREATE TABLE align2 AS SELECT 1::int4, 3::int4 AS more, 2::int8 FROM generate_series(1, 100000) _(i);" | |
| - name: Test wide mode | |
| run: | | |
| echo "\set postgres_dba_wide true" > ~/.psqlrc | |
| echo "\set postgres_dba_interactive_mode false" >> ~/.psqlrc | |
| for f in sql/*; do | |
| echo "Testing $f in wide mode..." | |
| if ! psql -d test -f warmup.psql -f "$f" > /dev/null 2>&1; then | |
| echo "FAILED: $f in wide mode" | |
| psql -d test -f warmup.psql -f "$f" | |
| exit 1 | |
| fi | |
| done | |
| - name: Test normal mode | |
| run: | | |
| echo "\set postgres_dba_wide false" > ~/.psqlrc | |
| echo "\set postgres_dba_interactive_mode false" >> ~/.psqlrc | |
| for f in sql/*; do | |
| echo "Testing $f in normal mode..." | |
| if ! psql -d test -f warmup.psql -f "$f" > /dev/null 2>&1; then | |
| echo "FAILED: $f in normal mode" | |
| psql -d test -f warmup.psql -f "$f" | |
| exit 1 | |
| fi | |
| done | |
| - name: Run regression tests | |
| run: | | |
| echo "\set postgres_dba_wide false" > ~/.psqlrc | |
| echo "\set postgres_dba_interactive_mode false" >> ~/.psqlrc | |
| echo "Running regression test for 0_node.sql..." | |
| diff -b test/regression/0_node.out <(psql -d test -f warmup.psql -f sql/0_node.sql | grep Role) | |
| echo "Running regression test for p1_alignment_padding.sql..." | |
| diff -b test/regression/p1_alignment_padding.out <(psql -d test -f warmup.psql -f sql/p1_alignment_padding.sql | grep align) | |
| echo "Running regression test for a1_activity.sql..." | |
| diff -b test/regression/a1_activity.out <(psql -d test -f warmup.psql -f sql/a1_activity.sql | grep User) | |