From: | pres <pgn(dot)lists(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: which database to login to to create global users? |
Date: | 2006-01-03 21:06:48 |
Message-ID: | c465caf0601031306p78f2e85co25b50fda011909ab@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
hello tom,
On 1/3/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> pres <pgn(dot)lists(at)gmail(dot)com> writes:
> > so, if i understand you correctly, it does not matter which database i'm
> > logged into when i create a role?
>
> Correct.
>
> > where (what database/table), then, are theses assignments stored?
>
> The info related to roles is stored in some "shared" catalogs that are
> visible in every database --- just the same way that pg_database is
> visible in every database. Try this to see which catalogs are shared:
>
> select relname from pg_class where relisshared and relkind = 'r';
>
> See also the documentation on the system catalogs:
> http://www.postgresql.org/docs/8.1/static/catalogs.html
> The description of each catalog takes care to mention it if the catalog
> is shared across databases.
>
> regards, tom lane
>
thank you for the clarification & reference. exactly what i needed.
i must admit that i'd managed to get a completely different, and incorrect,
understanding from the documentation ... i think i was carrying over the
(my?) "old way" of doing things.
i think i'd best reread the roles section after reading your reference
above.
thank you again.
pres
From | Date | Subject | |
---|---|---|---|
Next Message | pres | 2006-01-03 21:14:17 | Re: which database to login to to create global users? |
Previous Message | Tom Lane | 2006-01-03 20:57:20 | Re: which database to login to to create global users? |