PostgreSQL pg_hba.conf File Edit
Reference Contents > Optional Special User Functions > PostgreSQL pg_hba.conf File Edit
This window is used by an IT proffessional to control access to a PostgreSQL server. It is opened when the pg_hba.conf button is clicked on the PostgreSQL Server Statistics window.
|
Field |
Description |
|---|---|
|
Line No |
The line number of the original file. |
|
Enabled chexkbox |
Check to enable the entry. |
|
Type |
This can be “host”, “local”, “hostssl” etc. See PostgreSQL documentation. |
|
Database |
Use “all” or a comma-delimited list of databases. |
|
User |
Use “all” or a comma-delimited list of users and/or roles. |
|
Address |
TCP/IP address and mask. 192.168.0.1/24 means all addreses starting 192.168.0. |
|
Method |
md5 almost always. See PostgreSQL documentation. |
|
Button |
Action |
|---|---|
|
Close |
Click ito close this window without changing any data. |
|
Save |
Click to save any changes. This backs up the existing pg_hba.conf file to pg_hba.conf.bak, rebuilds the new one with any additions or changes you have made, Then issues the server with a command to reload it’s configuration. Any future connection attempts will be subject to the new settings. |
| See also: – |
Compiled in Program Version 5.10. Help data last modified 21 Jun 2018 07:31:20.37. Class wOptPgHbaEdit last modified 21 Jun 2018 07:00:16.
Reference Contents > Optional Special User Functions > PostgreSQL pg_hba.conf File Edit
