setup-postgres

The missing action for Postgres 🎉

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

Getting Started

Add it as a step to your workflow

    - uses: ankane/setup-postgres@v1

Versions

Specify a version (defaults to the latest)

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

Currently supports 13, 12, 11, 10, and 9.6. Only the latest version is supported on Windows.

Test against multiple versions

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

Extra Steps

Create a database

    - run: createdb testdb

Run queries

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

Config

Set postgresql.conf config

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

Related Actions

• setup-mysql
• setup-mariadb
• setup-mongodb
• setup-elasticsearch

Contributing

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