Skip to content

PG error when creating baseline version #1010

@holstvoogd

Description

@holstvoogd

I am trying to initialize project with pgroll, after some struggle with figuring out how to connect, i now just get this error when creating the base-line:

pgroll baseline 01_initial_schema db/pgroll --verbose --postgres-url='postgresql://127.0.0.1:5432/app_development?sslmode=disable'
Creating a baseline migration will restart the migration history.
Please confirm [y/N]: Yes
2025-12-18 15:18:18 INFO  Creating baseline version %q for schema %q
                      └ ERROR: key_without_value: [01_initial_schema public]
 SUCCESS  Baseline created successfully. Placeholder migration "db/pgroll/01_initial_schema.yaml" written

However, it was not the success it seems to suggest, the file is just this:

operations:
- sql:
    up: ""

I can confirm that I can connect using that connection string and that there is a public schema. It's pretty large and has everything weird you can imagine (or i can atleast) from enums, views, functions and custom checks/triggers.

Am I misunderstanding how this should work?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions