Re: [GENERAL] create user, user exists

2001-03-17 Thread Peter Eisentraut
Ron Peterson writes: > So now I'm trying to decide whether I want to use 'password' or > pg_shadow for user authentication. Using 'password' seems like a broad > (and easily managed) brush, while using groups would give me a finer > degree of control over permission settings. The ability to use

Re: [GENERAL] create user, user exists

2001-03-17 Thread Ron Peterson
Tom Lane wrote: > > Ron Peterson <[EMAIL PROTECTED]> writes: > > I'm having a bit of authentication trouble. I'm trying to use 'crypt' > > authentication. PostgreSQL 7.1beta5. My pg_hba.conf is as follows: > > IIRC, you can't use crypt with a flat password file, you have to use > plain passwd

Re: [GENERAL] create user, user exists

2001-03-17 Thread Richard Huxton
From: "Ron Peterson" <[EMAIL PROTECTED]> > I'm having a bit of authentication trouble. I'm trying to use 'crypt' > authentication. PostgreSQL 7.1beta5. My pg_hba.conf is as follows: > > #local all trust > local all crypt passtest > > When I do 'local all trust', everything works fine. When I