> adrian.klaver@xxxxxxxxxxx wrote: > >> bryn@xxxxxxxxxxxx wrote: >> >>> tgl@xxxxxxxxxxxxx wrote: >>> >>> ... >> >> 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. > > Which is documented here: > > www.postgresql.org/docs/current/app-postgres.html#APP-POSTGRES-SINGLE-USER Yes, after Tom's hint, a search for "single-user" took me to that page. But, beginner as I am, I didn't know that single-user mode was the thing that I needed. I need a remedial class. Something like "PostgreSQL for those whose mental model has been conditioned by decades of working with Oracle Database".
