Home Explore Blog CI



postgresql

15th chunk of `doc/src/sgml/system-views.sgml`
79c696ca46536462052f9796e57cf530f078b7f1b1792b710000000100000fb0
 role="catalog_table_entry"><para role="column_definition">
       <structfield>type</structfield> <type>text</type>
      </para>
      <para>
       Type of connection
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>database</structfield> <type>text[]</type>
      </para>
      <para>
       List of database name(s) to which this rule applies
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>user_name</structfield> <type>text[]</type>
      </para>
      <para>
       List of user and group name(s) to which this rule applies
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>address</structfield> <type>text</type>
      </para>
      <para>
       Host name or IP address, or one
       of <literal>all</literal>, <literal>samehost</literal>,
       or <literal>samenet</literal>, or null for local connections
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>netmask</structfield> <type>text</type>
      </para>
      <para>
       IP address mask, or null if not applicable
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>auth_method</structfield> <type>text</type>
      </para>
      <para>
       Authentication method
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>options</structfield> <type>text[]</type>
      </para>
      <para>
       Options specified for authentication method, if any
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>error</structfield> <type>text</type>
      </para>
      <para>
       If not null, an error message indicating why this
       line could not be processed
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>

  <para>
   Usually, a row reflecting an incorrect entry will have values for only
   the <structfield>line_number</structfield> and <structfield>error</structfield> fields.
  </para>

  <para>
   See <xref linkend="client-authentication"/> for more information about
   client authentication configuration.
  </para>
 </sect1>

 <sect1 id="view-pg-ident-file-mappings">
  <title><structname>pg_ident_file_mappings</structname></title>

  <indexterm zone="view-pg-ident-file-mappings">
   <primary>pg_ident_file_mappings</primary>
  </indexterm>

  <para>
   The view <structname>pg_ident_file_mappings</structname> provides a summary
   of the contents of the client user name mapping configuration file,
   <link linkend="auth-username-maps"><filename>pg_ident.conf</filename></link>.
   A row appears in this view for each non-empty, non-comment line in the file,
   with annotations indicating whether the map could be applied successfully.
  </para>

  <para>
   This view can be helpful for checking whether planned changes in the
   authentication configuration file will work, or for diagnosing a previous
   failure.  Note that this view reports on the <emphasis>current</emphasis>
   contents of the file, not on what was last loaded by the server.
  </para>

  <para>
   By default, the <structname>pg_ident_file_mappings</structname> view can be
   read only by superusers.
  </para>

  <table>
   <title><structname>pg_ident_file_mappings</structname> Columns</title> <tgroup
   cols="1">
    <thead>
     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       Column Type
      </para>
      <para>
       Description
      </para></entry>
     </row>
    </thead>

    <tbody>
     <row>
      <entry role="catalog_table_entry"><para role="column_definition">

Title: pg_ident_file_mappings View
Summary
The pg_ident_file_mappings view provides a summary of the client user name mapping configuration file, pg_ident.conf. It shows each non-empty, non-comment line in the file, with annotations indicating whether the map could be applied successfully. This view can be helpful for checking planned changes or diagnosing previous failures in the authentication configuration, but it can only be read by superusers by default.