On Wed, Sep 14, 2011 at 12:09 PM, Jaime Casanova <ja...@2ndquadrant.com> wrote:
> last time i tried it (last year), it seems broken because i couldn't > log in with any user anymore... but it could be that i did something > wrong so i didn't report until i could confirm but i hadn't the time > and i forgot it since then I haven't tried it on 9.0/9.1, but I used it on a 8.4 cluster, and "it worked", with all the caveats of needing all the user@database users created correctly, and the right use of quoting, and @ in logins, etc.... The biggest being the lack of md5... Definitely not "straight forward", and users are still "global", just suffixed with an "@database" to make then "unique" between database namespaces. But I found it useful when needing to hand out "seperate" usernames for different apps because they all needed to have their own search_path and other settings set before login (yes, dumb apps, mostly odbc), and be able to have the same "userid" for different databases, using different settings... a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like a slave. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
