PostgreSQL Application

This article serves as a guide on how to access a PostgreSQL application through Safous.

To access a PostgreSQL application created by an administrator, a user needs to:

• Have completed MFA enrollment and be able to log in successfully
• Be authorized by the configured access policies to access the application

Once the user logs in, all applications that the user is authorized to access will be displayed. To display only PostgreSQL applications, click the 'Protocol' filter and select 'PostgreSQL'. Select the PostgreSQL application created by the administrator. 

A new tab will open and display connection details for the PostgreSQL session.

• jdbc: Use a JDBC-compatible application to connect to the remote PostgreSQL database. Copy the generated JDBC connection URL and use it in your database application to establish the connection.
• PostgreSQL: Use a PostgreSQL-compatible database client to connect to the remote PostgreSQL database. Copy the generated connection information and enter it into your PostgreSQL client to establish the connection.
• psql: Use the psql command-line tool to connect to the remote PostgreSQL database. Copy the generated command and paste it into your terminal or shell to establish the connection.

Below is an example screenshot of a database connection: