Skip to content
You're viewing an older version of this GitHub Action. Do you want to see the latest version instead?
database

GitHub Action

Setup PostgreSQL for Linux/macOS/Windows

v6

Setup PostgreSQL for Linux/macOS/Windows

database

Setup PostgreSQL for Linux/macOS/Windows

Setup a preinstalled PostgreSQL server

Installation

Copy and paste the following snippet into your .yml file.

 
              
- name: Setup PostgreSQL for Linux/macOS/Windows

              
  uses: ikalnytskyi/action-setup-postgres@v6
Learn more about this action in ikalnytskyi/action-setup-postgres

Choose a version

setup-postgres

This action sets up a PostgreSQL server for the rest of the job. Here are some key features:

Usage

Important

In order to connect to a PostgreSQL server, use either connection parameters from the table below (link), or retrieve a connection URI from the connection-uri output (link).

Tip

libpq-using applications may choose to set the PGSERVICE=postgres environment variable instead (link), where postgres is the service name extracted from the service-name output.

Connection parameters

Key Value
URI postgresql://postgres:postgres@localhost/postgres
Host localhost
Port 5432
Username postgres
Password postgres
Database postgres
Service postgres

User permissions

Key Value
usesuper true
usecreatedb true

Basic

steps:
  - uses: ikalnytskyi/action-setup-postgres@v6

Advanced

steps:
  - uses: ikalnytskyi/action-setup-postgres@v6 
    with:
      username: ci
      password: sw0rdfish
      database: test
      port: 34837
    id: postgres

  - run: pytest -vv tests/
    env:
      CONNECTION_STR: ${{ steps.postgres.outputs.connection-uri }}

  - run: pytest -vv tests/
    env:
      CONNECTION_STR: service=${{ steps.postgres.outputs.service-name }}

Recipes

Create a new user w/ database via CLI

steps:
  - uses: ikalnytskyi/action-setup-postgres@v6 

  - run: |
      createuser myuser
      createdb --owner myuser mydatabase
      psql -c "ALTER USER myuser WITH PASSWORD 'mypassword'"
    env:
      # This activates connection parameters for the superuser created by
      # the action in the step above. It's mandatory to set this before using
      # createuser/psql and other libpq-using applications.
      #
      # The service name is the same as the username (i.e. 'postgres') but
      # it's recommended to use action's output to get the name in order to
      # be forward compatible.
      PGSERVICE: ${{ steps.postgres.outputs.service-name }}
    shell: bash

Create a new user w/ database via psycopg

steps:
  - uses: ikalnytskyi/action-setup-postgres@v6 
import psycopg

# 'postgres' is the username here, but it's recommended to use the
# action's 'service-name' output parameter here.
connection = psycopg.connect("service=postgres")

# CREATE/DROP USER statements don't work within transactions, and with
# autocommit disabled transactions are created by psycopg automatically.
connection.autocommit = True
connection.execute(f"CREATE USER myuser WITH PASSWORD 'mypassword'")
connection.execute(f"CREATE DATABASE mydatabase WITH OWNER 'myuser'")

Rationale

At the time of developing there were no GitHub Actions on the marketplace to setup a PostgreSQL server on Linux, Windows and macOS action runners. Most solutions suggest using Docker which is not available on macOS and Windows runners.

License

The scripts and documentation in this project are released under the MIT License.