---
title: "Advanced PostgreSQL Connection"
slug: "advanced-postgres-connection"
description: "Learn how to create and use a custom connection string to integrate with PostgreSQL, allowing specific parameters to be set to ensure a successful connection."
updated: 2026-07-02T13:53:09Z
published: 2026-07-02T13:53:09Z
canonical: "documentation.decisions.com/advanced-postgres-connection"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Advanced PostgreSQL Connection

## Overview

Creating and using a custom connection string to integrate with PostgreSQL allows specific parameters to be set to ensure a successful connection. The following article will show how the connection string should be configured to allow SSL.

The platform currently uses **Npgsql v5.0.7** to connect with PostgreSQL. By default, Npgsql will validate the server's certificate; this will fail if the certificate is self-signed. Instruct Npgsql to ignore this by specifying **Trust Server Certificate=true** in the connection string.

To precisely control how the server's certificate is validated, register **UserCertificateValidationCallback** on **NpgsqlConnection**.

This document is only meant to be used for making external integrations for PostgreSQL databases. Decisions does support PostgreSQL for the application server. Learn more in the [Installation Guide](https://documentation.decisions.com/version-10/docs/installation-guide).

### Additional Resources

- [Npgsql Connection String Parameters](https://www.npgsql.org/doc/connection-string-parameters.html?q=trust)
- [Npgsql Connection String Builder](https://www.npgsql.org/doc/api/Npgsql.NpgsqlConnectionStringBuilder.html)

---

## Setup

1. In the Folder Tree, navigate to **Projects > Manage > Integrations > Databases**.
2. Select **Create Connection** in the Top Bar.
3. In the **Database Integration** window, give the connection a **Name**, select **POSTGRES** as the **Database Type**.
4. Set **Custom Connection String** to **True**.
5. Edit the below example string parameters to match the Npgsql properties and place the string into the **Connection String** text box.

```actionscript
Host=hostname;Database=databasename;Port=5432;Integrated Security=False;Username=postgres;Password=xxx;TrustServerCertificate=True
```

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1783000370937.png)