Re: db_user_namespace, md5 and changing passwords

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Fernando Moreno <azazel(dot)7(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: db_user_namespace, md5 and changing passwords
Date: 2008-10-14 23:17:44
Message-ID: 200810142317.m9ENHiw14284@momjian.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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 not when an specific
> database(+users) is backed up and restored in the same server, or when two
> or more databases (corresponding to different applications) try to create
> users with the same name.
>
> Right now there's only one database in the server, but the backup module
> should be ready to handle these situations in the future.

No, I have no suggested workaround.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-10-15 00:00:23 Re: Drupal and PostgreSQL - performance issues?
Previous Message Chris 2008-10-14 22:35:32 Re: Drupal and PostgreSQL - performance issues?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-10-14 23:40:53 Bogus attribute-number range checks in spi.c
Previous Message David E. Wheeler 2008-10-14 22:16:18 Re: Version Number Function?