Creating Postgres read-only user fails #121

New Issue

MrUnknownDE · 2026-04-05T16:15:48+02:00

MrUnknownDE commented

2026-04-05 16:15:48 +02:00

Originally created by @skilar on 2/19/2026

When trying to create a read-only user in Postgres 17 (on Supabase), I receive this error:

failed to verify user creation: ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02)

I'm using the latest version of Databasus, v3.14.1. I'm seeing these two messages in the Pooler logs in Supabase:

"ClientHandler: socket closed with reason {:shutdown, :terminate_received}, DbHandler {#PID<0.16481.5126>, {:idle, :session}}"
"DbHandler: Terminating with reason :client_termination when state was :idle"

*Originally created by @skilar on 2/19/2026* When trying to create a read-only user in Postgres 17 (on Supabase), I receive this error: ```failed to verify user creation: ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02)``` I'm using the latest version of Databasus, v3.14.1. I'm seeing these two messages in the Pooler logs in Supabase: ```"ClientHandler: socket closed with reason {:shutdown, :terminate_received}, DbHandler {#PID<0.16481.5126>, {:idle, :session}}"``` ```"DbHandler: Terminating with reason :client_termination when state was :idle"```

MrUnknownDE closed this issue

2026-04-05 16:15:48 +02:00

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/databasus#121