1. Home
  2. Optional Special User Functions
  3. Optional Special User Functions: PostgreSQL pg_hba.conf File Edit

Optional Special User Functions: PostgreSQL pg_hba.conf File Edit

PostgreSQL pg_hba.conf File Edit

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.

Updated on May 27, 2020

Was this article helpful?

Related Articles

Leave a Comment