Re: I slipped up so that no existing role allows connection. Is rescue possible?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bryn Llewellyn <bryn(at)yugabyte(dot)com>
Cc: pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: I slipped up so that no existing role allows connection. Is rescue possible?
Date: 2022-09-19 22:15:38
Message-ID: 537913.1663625738@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bryn Llewellyn <bryn(at)yugabyte(dot)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.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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2022-09-19 22:18:08 Re: I slipped up so that no existing role allows connection. Is rescue possible?
Previous Message Bryn Llewellyn 2022-09-19 22:06:02 I slipped up so that no existing role allows connection. Is rescue possible?