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

["Theodore M Rolle, Jr." <stercor@xxxxxxxxx>]

.

.

.

And Tom’s English is excellent!

On Tue, Sep 20, 2022, 18:29 Mladen Gogala <gogala.mladen@xxxxxxxxx> wrote:

On 9/19/22 18:15, Tom Lane wrote:

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

Tom, your knowledge is vast and your advice is extremely useful. Have you ever considered creating a dedicated page for beginners? Something like AskTom.postgresql.org would probably be appropriate.

Regards

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com