diff options
author | Robert Haas <rhaas@postgresql.org> | 2010-09-13 17:03:23 +0000 |
---|---|---|
committer | Robert Haas <rhaas@postgresql.org> | 2010-09-13 17:03:23 +0000 |
commit | 3b08e09fe7bc2640930aaa9e6d284700f4920f5f (patch) | |
tree | fe5f0b84dc95e1dc55f5223d2b9f4c641ebd2c0a | |
parent | d9ac2fdaa96d85830925151aa5751ee79aa6b01d (diff) | |
download | postgresql-3b08e09fe7bc2640930aaa9e6d284700f4920f5f.tar.gz |
Elaborate on what gets stored in pg_authid.rolpasswd.
Also, add cross-reference from pg_shadow.passwd to pg_authid.rolpasswd and
fix a bit of markup I muffed in my previous commit.
Per discussion with Josh Kupershmidt.
-rw-r--r-- | doc/src/sgml/catalogs.sgml | 17 |
1 files changed, 13 insertions, 4 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 7889651e18..c1c7a2ab62 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.225.2.3 2010/09/13 01:25:12 rhaas Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.225.2.4 2010/09/13 17:03:23 rhaas Exp $ --> <!-- Documentation of the system catalogs, directed toward PostgreSQL developers --> @@ -1179,7 +1179,14 @@ <row> <entry><structfield>rolpassword</structfield></entry> <entry><type>text</type></entry> - <entry>Password (possibly encrypted); null if none</entry> + <entry> + Password (possibly encrypted); null if none. If the password is + encrypted, this column will contain the string md5 followed by a + 32-character hexadecimal MD5 hash. The MD5 hash will be of the + user's password concatenated to their username (for example, if + user joe has password xyzzy, <productname>PostgreSQL</> will store + the md5 hash of xyzzyjoe). + </entry> </row> <row> @@ -6937,7 +6944,7 @@ <productname>PostgreSQL</productname> before version 8.1. It shows properties of all roles that are marked as <structfield>rolcanlogin</> in - <link linkend="catalog-pg-authid">pg_authid</link>. + <link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>. </para> <para> @@ -7004,7 +7011,9 @@ <entry><structfield>passwd</structfield></entry> <entry><type>text</type></entry> <entry></entry> - <entry>Password (possibly encrypted)</entry> + <entry>Password (possibly encrypted); null if none. See + <link linkend="catalog-pg-authid"><structname>pg_authid</structname></link> + for details of how encrypted passwords are stored.</entry> </row> <row> |