PostgreSQL

For PostgreSQL:

New Server Connection panel for a PostgreSQL server connection

Providing the basic connection information

1. In the Host field, provide the hostname for the server.

2. In the Port field, provide the port to connect through.

3. From the SSL/TLS dropdown list, select whether to enable or require Secure Socket Layer (SSL) or Transport Layer Security (TLS).

   If you select either Verify CA or Verify Full, you must add the required certificate to the account certificates list.

Connecting through an SSH tunnel

To connect through an SSH tunnel:

1. Check the Connect through a tunnel checkbox.

2. From the Tunnel dropdown list, either:

   1. Select an existing network tunnel to use.

   2. To create a new tunnel, select Add a new workspace network tunnel.

If you select the option to create a new tunnel, Fabricate displays the Add Network Tunnel panel for you to configure the new tunnel.

For information about how to configure a network tunnel, go to Adding a tunnel.

Configuring the authentication

Selecting the authentication method

From the Authentication dropdown list, select the type of authentication to use.

The options are:

• Username & Password. This is the default.

• AWS IAM Role. To use this option, you must first configure the available AWS roles for the workspace.

• Azure AD Service Principal. To use this option, you must first configure the available Azure service principals for the workspace.

Providing a username and password

For username and password authentication:

1. In the Username field, provide the username to use to make the connection.

2. In the Password field, provide the password.

Providing an AWS role

For AWS IAM role authentication:

1. In the Username field, provide the username to use to make the connection.

2. From the AWS Role dropdown, select the role to use.

Providing an Azure service principal

For Azure AD service principal authentication:

1. In the Username field, provide the username for the Microsoft Entra user to use to make the connection. The user must be mapped to the service principal that you select.

2. From the Azure Service Principal dropdown, select the service principal to use.