timescaledb-extras diagnostic #143
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
| # Test diagnostic script from timescaledb-extras works | |
| name: "timescaledb-extras diagnostic" | |
| "on": | |
| schedule: | |
| # run daily 0:00 on main branch | |
| - cron: '0 0 * * *' | |
| pull_request: | |
| paths: .github/workflows/extras-diagnostic.yaml | |
| push: | |
| branches: | |
| - trigger/package_test | |
| workflow_dispatch: | |
| jobs: | |
| diagnostic_test: | |
| name: timescaledb-extras PG${{ matrix.pg }} nightly | |
| runs-on: ubuntu-latest | |
| services: | |
| ts: | |
| image: timescaledev/timescaledb:nightly-pg${{ matrix.pg }} | |
| ports: | |
| - 5432:5432 | |
| env: | |
| POSTGRES_HOST_AUTH_METHOD: trust | |
| POSTGRESQL_PASSWORD: ci | |
| env: | |
| PGHOST: localhost | |
| PGUSER: postgres | |
| PGPASSWORD: ci | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| pg: [15,16,17,18] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| with: | |
| repository: 'timescale/timescaledb-extras' | |
| - name: Wait for services to start | |
| run: | | |
| sleep 10 | |
| pg_isready -t 30 | |
| - name: Prepare database | |
| run: | | |
| psql -v ON_ERROR_STOP=1 -c "$(cat <<SQL | |
| SELECT version(); | |
| SELECT extname, extversion from pg_extension; | |
| CREATE TABLE t(time timestamptz) WITH (tsdb.hypertable); | |
| INSERT INTO t SELECT '2025-01-01'; | |
| INSERT INTO t SELECT '2025-02-01'; | |
| SELECT compress_chunk(show_chunks('t')); | |
| SQL | |
| )" | |
| - name: Run diagnostic script | |
| run: | | |
| psql -v ON_ERROR_STOP=1 < diagnostic.sql | |