Bryn Llewellyn <bryn@xxxxxxxxxxxx> 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.5 software 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
