Kevin O'Gorman writes:
> In any event when I start the backend standalone (i.e. running
> the 'postgres -D ....' command, it seems I have to be the root
> or postgres root user because of file permissions.
Yup.
> But I want access to the database of my normal username, which is
> 'kevin'.
postgres [options] dbname
> Questions: have I identified the problem right? Is that why I
> can't see my tables? If so, is there a way to change databases,
> given that the \ commands don't work in the backend?
Not sure when a \ command *changed* a database last time.
> Or am I just going at this all wrong in some way?
There's probably little reason to start a backend standalone. If you want
to do stock-of-the-trade debugging you simply start a postmaster, then
psql (or whatever floats your boat), and attach gdb to the resulting
backend process.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/