Set Up PostgreSQL Authentication

Create a PostgreSQL record in order to authenticate to a PostgreSQL database instance running on a Unix host, and scan it for compliance. Unix authentication is required so you'll also need a Unix record 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.

Which technologies are supported?

- PostgreSQL 9.x, 10.x, 11.x

How do I get started?

- Go to Scans > Authentication.

- Check that you have a Unix record already defined for the host running the database.

- Create a PostgreSQL record for the same host. Go to New > PostgreSQL Record.

Tell me about user permissions

Your record settings

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).

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 on all IPs listed in the record. If the file is in a different location for some hosts you must create additional records for those hosts.

 

Quick Links

Why use host authentication

Setup for PostgreSQL (PC) Zip File Icon