Re: 'postgres' flag

"Mike Rogers" <temp6453@hotmail.com> writes:
>     Anyone have a code hack to 7.1 to make postgreSQL break out of the
> 'sameuser' jail if a user as the 'postgres' superuser flag?

The difficulty with that idea is that the connection-matching code has
no idea whether a given userid is superuser or not (indeed, that info
is not available to the postmaster at all).

> Or maybe to set
> config file lines based also on 'superuser' (like 'crypt superuser' or
> something like that).  Otherwise I think I might make one.

Did you read the thread a day or two back in pgsql-admin?  Consider
something like
local    sameuser    passwordlocal    all        password crossauth

where crossauth contains the usernames you want to allow to connect
to databases other than their own.
        regards, tom lane