Re: Need a debugging tip or two

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/