sqlx-cli regression in 0.9.0: role "anonymous" does not exist

[flisk]

I have found these related issues/pull requests

I have found no existing issues for this problem.

Description

After upgrading sqlx-cli to 0.9.0, running any database-related task (create, drop, reset, run migrations) in my environment results in this error:

error: error returned from database: role "anonymous" does not exist at line 799

I am running sqlx under macOS against PostgreSQL 17.9, with ident-based authentication. I can provide further details if needed. I am frankly not sure how to debug this.

The issue is not reproducible with sqlx-cli 0.8.6, so I'm back to this version for now.

Reproduction steps

I am unsure what to provide here. sqlx database reset reproduces the issue for me, but I don't know how much of my environment is required for this issue to reproduce reliably.

SQLx version

0.9.0

Enabled SQLx features

bigdecimal, chrono, postgres, runtime-tokio, uuid

Database server and version

PostgreSQL 17.9

Operating system

macOS 26.5

Rust version

rustc 1.95.0 (59807616e 2026-04-14)

[flisk]

This actually seems to not be limited to sqlx-cli, I saw the same thing happen when I tried upgrading my sqlx dependency to 0.9.0 just now. Also of note, my DATABASE_URL was previously postgres://localhost/mydatabase. If I explicitly add my OS username like postgres://foobert@localhost/mydatabase, the error clears.

[svnrb]

I have a pull request open to fix this: #4275