Re: Authenticating some users and trusting others

Lio Test writes:

> I want to avoid that someone could authenticate as root user on my
> databases. For this, I would like to apply "trust" access mode mixed
> with auth by password for other users. In this case, someone would
> have first to gain root privileges on my Linux system to access PG as
> root.

Perhaps you are confused. There is nothing wrong with having a database
user called "root". This user does not automatically have special
privileges and is unrelated to any Unix root user.

> Is it possible to mix two auth modes ?

Not from the same host.


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden