setup-postgres

The missing action for Postgres 🎉

• Faster (with the default version) 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

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

Currently 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 }}

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'

Install development files (for building extensions)

      - uses: ankane/setup-postgres@v1
        with:
          dev-files: true

Extra Steps

Run queries

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

Related Actions

• setup-mysql
• setup-mariadb
• setup-mongodb
• setup-elasticsearch
• setup-opensearch
• setup-sqlserver

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