How to configure PostgreSQL data source profile in the SQL for Confluence app.

This article provides detailed guidance on configuring a PostgreSQL database source profile in the SQL for Confluence app.

Steps for Postgresql Source Profile

1. Navigate to the 'View and Modify Data Source' section. You can refer to the attached screenshot for guidance.
   
   

   Open

   

    

2. Click the 'Add Profile' button to create a new data profile. To add the profile, you have to provide the details below.
   
   

   Open

   

    

3. For a sample configuration, you can refer to the details provided below:

   1. Profile name: You can give any name here for the profile.

   2. Database type: For Postgres, you have to select POSTGRESQL.

   3. Hostname: dockersupphost4.bobfire.com

   4. Port: 50147 (Default Port: 5432)

   5. Database: Confluence

   6. Driver class: org.postgresql.Driver

   7. Driver JAR location: https://jdbc.postgresql.org/download/postgresql-42.2.5.jar

   8. Username: automation

   9. Password: automation
      
      

4. After entering the details, click the 'Test Connection' button to check the connection. If all the information is accurate, you should receive a success message, as depicted in the screenshot below.
   
   

   Open