From: | "Theodore M Rolle, Jr(dot)" <stercor(at)gmail(dot)com> |
---|---|
To: | Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com> |
Cc: | 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-20 22:54:29 |
Message-ID: | CAPDmd-BwsXR4iOAdiM_oVWoeBqULDDfRJeH+FgyFWVZyg8nmxQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
.
.
.
And Tom’s English is excellent!
On Tue, Sep 20, 2022, 18:29 Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com> wrote:
> On 9/19/22 18:15, Tom Lane wrote:
>
> Bryn Llewellyn <bryn(at)yugabyte(dot)com> <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
>
>
>
> 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-1217https://dbwhisperer.wordpress.com
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2022-09-20 23:21:43 | Re: tcp settings |
Previous Message | Mladen Gogala | 2022-09-20 22:29:44 | Re: I slipped up so that no existing role allows connection. Is rescue possible? |