The missing action for Postgres 🎉
- Faster (with the default version) and simpler than containers
- Works on Linux, Mac, and Windows
- Supports different versions
Add it as a step to your workflow
- uses: ankane/setup-postgres@v1Specify a version
- uses: ankane/setup-postgres@v1
with:
postgres-version: 17Currently supports
| Version | 17 |
16 |
15 |
14 |
13 |
12 |
|---|---|---|---|---|---|---|
| Ubuntu 24.04 | ✓ | default | ✓ | ✓ | ✓ | ✓ |
| Ubuntu (rest) | ✓ | ✓ | ✓ | default | ✓ | ✓ |
| Mac | ✓ | ✓ | ✓ | default | ✓ | ✓ |
| Windows | default |
Test against multiple versions
strategy:
matrix:
postgres-version: [17, 16, 15, 14, 13]
steps:
- uses: ankane/setup-postgres@v1
with:
postgres-version: ${{ matrix.postgres-version }}Create a database
- uses: ankane/setup-postgres@v1
with:
database: testdbSet postgresql.conf config
- uses: ankane/setup-postgres@v1
with:
config: |
shared_preload_libraries = 'pg_stat_statements'Install development files (for building extensions)
- uses: ankane/setup-postgres@v1
with:
dev-files: trueRun queries
- run: psql -d testdb -c 'SHOW server_version'Everyone is encouraged to help improve this project. Here are a few ways you can help:
- Report bugs
- Fix bugs and submit pull requests
- Write, clarify, or fix documentation
- Suggest or add new features