Re: I slipped up so that no existing role allows connection. Is rescue possible? - Mailing list pgsql-general

Bryn Llewellyn <bryn@yugabyte.com> writes:
> Is rescue possible? Or must I simply remove my cluster and use "pg_ctl" to create a new one within my existing PG
14.5software env? 

Stop the cluster, start a single-user session ("postgres --single"),
re-grant superuser to the postgres user and/or whatever else you
wish you could take back, end that session, restart the cluster.

(You're not the first to mess up like this.)

            regards, tom lane