Re: db_user_namespace a "temporary measure"

Поиск
Список
Период
Сортировка
От Aidan Van Dyk
Тема Re: db_user_namespace a "temporary measure"
Дата
Msg-id CAC_2qU-uGSRkaK-3HsMu9S-4UKyj0NV3sES+zr_dRjxJ3moXfQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: db_user_namespace a "temporary measure"  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-hackers
So I'll admit to using it, only in "toy" setups...

I use it with trust and ident, on local connections though, not password....

I try to keep my laptops clean of mysqld, and I use PG.  And only on my laptop/PC,  I make a database for every user...  And every "app" get's a userid, and a schema....    Every user get's passwordless access to their database.  And the "userid" associates the app, and the defaults that get used on their connections.

So, I think it's "neat", but wouldn't be put out if it was removed ...


On Tue, Mar 11, 2014 at 9:47 AM, Magnus Hagander <magnus@hagander.net> wrote:
On Tue, Mar 11, 2014 at 2:40 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Magnus Hagander <magnus@hagander.net> writes:
> On Sun, Mar 9, 2014 at 9:00 PM, Thom Brown <thom@linux.com> wrote:
>> It will be 12 years this year since this "temporary measure" was
>> added.  I'm just wondering, is there any "complete solution" that
>> anyone had in mind yet?  Or should this just be deprecated?

> I'd say +1 to remove it. That would also make it possible to get id of
> "password" authentication...

If we remove it without providing a substitute feature, people who are
using it will rightly complain.

Are you claiming there are no users, and if so, on what evidence?

I am claiming that I don't think anybody is using that, yes.

Based on the fact that I have *never* come across it on any system I've come across since, well, forever. Except once I think, many years ago, when someone had enabled it by mistake and needed my help to remove it...

But we should absolutely deprecate it first in that place. Preferrably visibly (e.g. with a log message when people use it). That could at least get those people who use it to let us know they do, to that way figure out if they do - and can de-deprecate it. 

Or if someone wants to fix it properly of course :)



--
Aidan Van Dyk                                             Create like a god,
aidan@highrise.ca                                       command like a king,
http://www.highrise.ca/                                   work like a slave.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: db_user_namespace a "temporary measure"
Следующее
От: Rajeev rastogi
Дата:
Сообщение: Re: COPY table FROM STDIN doesn't show count tag