tgl@xxxxxxxxxxxxx wrote:bryn@xxxxxxxxxxxx writes: So nice to find this waiting for me when I got back to the keyboard after a late lunch. Thanks, Tom. And thanks to David, too who said much the same. I'll note how I spelled the magic—as a little memo for me: postgres --single -D /usr/local/var/postgres postgres The world that the "backend> " prompt opened up for me was rather basic. But even so, "alter user postgres with superuser" worked fine. (This was the only rescue that I needed.) And, after a normal restart, everything looks normal again now from the psql prompt. This leads to some follow-up questions. But I'll start a new thread. |
