meta données pour cette page
  •  

Ceci est une ancienne révision du document !

Configuration PostGreSQL 16

  • Lister la conf actuelle
postgres=# table pg_hba_file_rules ;
 rule_number |          file_name          | line_number | type  |   database    | user_name |  address  |                 netmask                 | auth_method | options | error 
-------------+-----------------------------+-------------+-------+---------------+-----------+-----------+-----------------------------------------+-------------+---------+-------
           1 | /u01/pgsql/data/pg_hba.conf |         117 | local | {all}         | {all}     |           |                                         | trust       |         | 
           2 | /u01/pgsql/data/pg_hba.conf |         119 | host  | {all}         | {all}     | 127.0.0.1 | 255.255.255.255                         | trust       |         | 
           3 | /u01/pgsql/data/pg_hba.conf |         121 | host  | {all}         | {all}     | ::1       | ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff | trust       |         | 
           4 | /u01/pgsql/data/pg_hba.conf |         124 | local | {replication} | {all}     |           |                                         | trust       |         | 
           5 | /u01/pgsql/data/pg_hba.conf |         125 | host  | {replication} | {all}     | 127.0.0.1 | 255.255.255.255                         | trust       |         | 
           6 | /u01/pgsql/data/pg_hba.conf |         126 | host  | {replication} | {all}     | ::1       | ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff | trust       |         | 
(6 lignes)