/setup-postgres

The missing action for Postgres

Primary LanguageJavaScriptMIT LicenseMIT

setup-postgres

The missing action for Postgres 🎉

  • Faster and simpler than containers
  • Works on Linux, Mac, and Windows
  • Supports different versions

Build Status

Getting Started

Add it as a step to your workflow

    - uses: ankane/setup-postgres@v1

Versions

Specify a version

    - uses: ankane/setup-postgres@v1
      with:
        postgres-version: 14

Currently supports

Version 14 13 12 11 10 9.6
Ubuntu default ✓ ✓ ✓ ✓ ✓
Mac default ✓ ✓ ✓ ✓
Windows default

Test against multiple versions

    strategy:
      matrix:
        postgres-version: [14, 13, 12, 11, 10, 9.6]
    steps:
    - uses: ankane/setup-postgres@v1
      with:
        postgres-version: ${{ matrix.postgres-version }}

Options

Create a database

    - uses: ankane/setup-postgres@v1
      with:
        database: testdb

Set postgresql.conf config

    - uses: ankane/setup-postgres@v1
      with:
        config: |
          shared_preload_libraries = 'pg_stat_statements'

Extra Steps

Run queries

    - run: psql -d testdb -c 'SHOW server_version'

Related Actions

Contributing

Everyone is encouraged to help improve this project. Here are a few ways you can help: