postgres.git / summary / log / commit / refs

commit    dc70816fde6e370d5d3afc627dbe6caaf7f81be0
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Tue Jul 15 22:53:00 2025 +0000
First released in: 13.22, 14.19, 15.14, 16.10, 17.6, 18.0

    Doc: clarify description of regexp fields in pg_ident.conf.
    
    The grammar was a little shaky and confusing here, so word-smith it
    a bit.  Also, adjust the comments in pg_ident.conf.sample to use the
    same terminology as the SGML docs, in particular "DATABASE-USERNAME"
    not "PG-USERNAME".
    
    Back-patch appropriate subsets.  I did not risk changing
    pg_ident.conf.sample in released branches, but it still seems OK
    to change it in v18.
    
    Reported-by: Alexey Shishkin <alexey.shishkin@enterprisedb.com>
    Author: Tom Lane <tgl@sss.pgh.pa.us>
    Reviewed-by: David G. Johnston <david.g.johnston@gmail.com>
    Discussion: https://postgr.es/m/175206279327.3157504.12519088928605422253@wrigleys.postgresql.org
    Backpatch-through: 13


doc/src/sgml/client-auth.sgml | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/client-auth.sgml b/doc/src/sgml/client-auth.sgml index 3e7a9efd8cc..dd82e8af0d7 100644 --- a/doc/src/sgml/client-auth.sgml +++ b/doc/src/sgml/client-auth.sgml @@ -838,8 +838,9 @@ local db1,db2,@demodbs all md5 the remainder of the field is treated as a regular expression. (See <xref linkend="posix-syntax-details"/> for details of <productname>PostgreSQL</productname>'s regular expression syntax.) The regular - expression can include a single capture, or parenthesized subexpression, - which can then be referenced in the <replaceable>database-username</replaceable> + expression can include a single capture, or parenthesized subexpression. + The portion of the system user name that matched the capture can then + be referenced in the <replaceable>database-username</replaceable> field as <literal>\1</literal> (backslash-one). This allows the mapping of multiple user names in a single line, which is particularly useful for simple syntax substitutions. For example, these entries [parent: 6c93bf735ce1]