Re: [GENERAL] db_user_namespace, md5 and changing passwords

2008-11-11 Thread Magnus Hagander
Bruce Momjian wrote: > Bruce Momjian wrote: >> Alvaro Herrera wrote: >>> Tom Lane escribi?: Bruce Momjian <[EMAIL PROTECTED]> writes: > I don't know of a way to make MD5 and db_user_namespace work cleanly so > we are considering removing db_user_namespace in 8.4. We are? It's no

Re: [GENERAL] db_user_namespace, md5 and changing passwords

2008-11-10 Thread Bruce Momjian
Bruce Momjian wrote: > Alvaro Herrera wrote: > > Tom Lane escribi?: > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > > I don't know of a way to make MD5 and db_user_namespace work cleanly so > > > > we are considering removing db_user_namespace in 8.4. > > > > > > We are? It's no more or les

Re: [GENERAL] db_user_namespace, md5 and changing passwords

2008-10-14 Thread Bruce Momjian
Fernando Moreno wrote: > Thanks for the answers, I wasn't aware of the conflict between md5-auth and > db_user_namespace, but it seems highly related to my problem. > > Could you suggest me another way to handle this? Managing users in the usual > way is likely to work fine most of the time, but n

Re: [GENERAL] db_user_namespace, md5 and changing passwords

2008-10-14 Thread Fernando Moreno
2008/10/7 Alvaro Herrera <[EMAIL PROTECTED]> > Bruce Momjian escribió: > > > Well, I posted about this in August with no one replying: > > > > http://archives.postgresql.org/pgsql-admin/2008-08/msg00068.php > > > > Basically, there is a mismatch between what libpq and the backend think > > i

Re: [GENERAL] db_user_namespace, md5 and changing passwords

2008-10-07 Thread Alvaro Herrera
Bruce Momjian escribió: > Well, I posted about this in August with no one replying: > > http://archives.postgresql.org/pgsql-admin/2008-08/msg00068.php > > Basically, there is a mismatch between what libpq and the backend think > is the username, and that affects how MD5 uses the salt on t

Re: [GENERAL] db_user_namespace, md5 and changing passwords

2008-10-07 Thread Bruce Momjian
Alvaro Herrera wrote: > Tom Lane escribi?: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > I don't know of a way to make MD5 and db_user_namespace work cleanly so > > > we are considering removing db_user_namespace in 8.4. > > > > We are? It's no more or less ugly than the day it was put in (

Re: [GENERAL] db_user_namespace, md5 and changing passwords

2008-10-05 Thread Alvaro Herrera
Tom Lane escribió: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I don't know of a way to make MD5 and db_user_namespace work cleanly so > > we are considering removing db_user_namespace in 8.4. > > We are? It's no more or less ugly than the day it was put in (the > MD5 encryption option was al

Re: [GENERAL] db_user_namespace, md5 and changing passwords

2008-10-05 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I don't know of a way to make MD5 and db_user_namespace work cleanly so > we are considering removing db_user_namespace in 8.4. We are? It's no more or less ugly than the day it was put in (the MD5 encryption option was already there). If we had some i

Re: [GENERAL] db_user_namespace, md5 and changing passwords

2008-10-04 Thread Joshua D. Drake
Bruce Momjian wrote: Is there a way to avoid this problem without having to reset all passwords or storing them in plain text? I don't know of a way to make MD5 and db_user_namespace work cleanly so we are considering removing db_user_namespace in 8.4. I would +1 the removal. Joshua D. Dr

Re: [GENERAL] db_user_namespace, md5 and changing passwords

2008-10-04 Thread Bruce Momjian
Fernando Moreno wrote: > Hi there, I'm going to use the db_user_namespace parameter to get a strong > relationship between roles and databases, multiple databases -users > included- residing in the same server without conflicts is my objective too. > > > Right now I'm working on the backup proces

[GENERAL] db_user_namespace, md5 and changing passwords

2008-10-04 Thread Fernando Moreno
Hi there, I'm going to use the db_user_namespace parameter to get a strong relationship between roles and databases, multiple databases -users included- residing in the same server without conflicts is my objective too. Right now I'm working on the backup process, which ideally would let me mirro