initdb: error: cannot be run as root

[fdejax90]

I use ikalnytskyi/action-setup-postgres@v7 to setup Postgres in my Github Action CI/CD pipeline, and I got the error below:

act -j db-migration-deploy -s GITHUB_TOKEN="$(gh auth token)"
>>>
...
[CI/CD Pipeline/Run Tests]   ✅  Success - Main Install PostgreSQL
[CI/CD Pipeline/Run Tests]   ⚙  ::add-path:: /usr/lib/postgresql/15/bin
[CI/CD Pipeline/Run Tests] ⭐ Run Main Setup and start PostgreSQL
[CI/CD Pipeline/Run Tests]   🐳  docker exec cmd=[bash --noprofile --norc -e -o pipefail /var/run/act/workflow/postgres-composite-1.sh] user= workdir=
| initdb: error: cannot be run as root
| initdb: hint: Please log in (using, e.g., "su") as the (unprivileged) user that will own the server process.
[CI/CD Pipeline/Run Tests]   ❌  Failure - Main Setup and start PostgreSQL
[CI/CD Pipeline/Run Tests] exitcode '1': failure
[CI/CD Pipeline/Run Tests]   ⚙  ::set-output:: connection-uri=
[CI/CD Pipeline/Run Tests]   ⚙  ::set-output:: service-name=
[CI/CD Pipeline/Run Tests]   ⚙  ::set-output:: certificate-path=
[CI/CD Pipeline/Run Tests]   ❌  Failure - Main Setup PostgreSQL
[CI/CD Pipeline/Run Tests] exitcode '1': failure
[CI/CD Pipeline/Run Tests] ⭐ Run Post Setup PostgreSQL
[CI/CD Pipeline/Run Tests]   🐳  docker cp src=/Users/floriandejax/.cache/act/ikalnytskyi-action-setup-postgres@v7/ dst=/var/run/act/actions/ikalnytskyi-action-setup-postgres@v7/
[CI/CD Pipeline/Run Tests]   ✅  Success - Post Setup PostgreSQL
[CI/CD Pipeline/Run Tests] 🏁  Job failed

Please find below the CI/CD pipeline:

name: CI/CD Pipeline

on:
  push:
    branches:
      - '**'  # Runs on pushes to any branch

env:
  AWS_ACCOUNT_ID: XXXXXXXXX

jobs:
  test:
    name: Run Tests
    runs-on: ubuntu-latest

    steps:

    - name: Check out repository code
      uses: actions/checkout@v4

    - name: Install uv
      uses: astral-sh/setup-uv@v4
      with:
        version: "latest"

    - name: Enable caching
      uses: astral-sh/setup-uv@v4
      with:
        enable-cache: true

    - name: Setup Python
      uses: actions/setup-python@v5
      with:
        python-version-file: "pyproject.toml"

    - name: Install dependencies
      run: |
        uv sync --all-extras --dev

    - name: Setup PostgreSQL
      uses: ikalnytskyi/action-setup-postgres@v7
      with:
        username: jason
        password: argos
        database: test_db
        port: 5432
        postgres-version: "15"
        ssl: "on"
      id: postgres

    - name: Run tests
      run: |
        uv run pytest
      env:
        CONNECTION_STR: ${{ steps.postgres.outputs.connection-uri }}