Create a PostgreSQL record in order to authenticate to a PostgreSQL database instance running on a Unix or Windows host, and scan it for compliance. Unix and Windows authentication is required so you'll also need a Unix and Windows record respectively for the host running the database.
This record type is only available in accounts with PC or SCA and is only supported for compliance scans.
- PostgreSQL 9.x, 10.x, 11.x, 12x
- Go to Scans > Authentication.
- Check that you have a Unix or Windows record already defined for the host running the database.
- Create a PostgreSQL record for the same host. Go to New > Databases > PostgreSQL.
Managers can add authentication records.
Unit Managers must be granted these permissions:
- Manage PC module / Manage SCA module
- Create/edit authentication records/vaults
You’ll need to tell us the user account to be used for authentication, the database instance to authenticate to, and the port where the database is installed.
The type of authentication method you use depends on your server settings and how you've configured client authentication.
You can use:
- a password (enter it on the Login Credentials tab or get it from a password vault),
- a client certificate (enter it on the Private Key / Certificate tab),
- a password AND client certificate (enter values on both tabs).
In order to perform OS-dependent compliance checks you'll need to tell us where the PostgreSQL configuration file is located on your Unix and/or Windows hosts.
On the Unix tab, tell us the full path to the PostgreSQL configuration file on your Unix hosts. The file must be in the same location for all Unix hosts in your record. If the file is in a different location for some hosts you must create additional records for those hosts. Unix authentication is also required to perform these checks so make sure you have a Unix record with the same Unix hosts as this record.
On the Windows tab, tell us the full path to the PostgreSQL configuration file on your Windows hosts. The file must be in the same location for all Windows hosts in your record. If the file is in a different location for some hosts you must create additional records for those hosts. Windows authentication is also required to perform these checks so make sure you have a Windows record with the same Windows hosts as this record.