Syncing 10,000 leads/mo? Get a demo
PostgreSQL logo

How to connect PostgreSQL with LeadsBridge

Integrate PostgreSQL with LeadsBridge

logo3078

Intro

PostgreSQL is an open source database, more specifically, it's an object-relational database management system with an emphasis on extensibility and standards compliance.

In this article, you'll learn how to connect your LeadsBridge account with PostgreSQL.

Connect PostgreSQL integration

Before you start

  1. Head over to the left sidebar and click on the Create new Bridge button
  2. Select your integrations in the selectors
  3. Click on the Continue button at the bottom right

Authorize PostgreSQL integration

Setup your PostgreSQL integration

  1. Click on Connect PostgreSQL
  2. Click on Create new integration to connect your PostgreSQL (or select an existing one from the dropdown if you already connected it)
  3. A popup wil be opened where you can authorize the PostgreSQL integration
  4. Fill Database host, Database name, Username, Password, Charset, Database Schema (Optional) field to connect PostgreSQL with LeadsBridge
  5. Click on the Authorize button
  6. You can choose a name for this PostgreSQL and LeadsBridge integration (you can also edit it later)
  7. Once done, click on Continue button and you will get back to the bridge experience where you could choose additional integration settings
  8. Now that your PostgreSQL is connected, you can continue with the set-up of your bridge

Which entity concepts we support for PostgreSQL

With LeadsBridge you may use these entity concepts for PostgreSQL.

  1. Row

    A row is a series of data banks laid out horizontally in a table or spreadsheet.

Which segmentation concepts we support for PostgreSQL

With LeadsBridge you may use these segmentation concepts for PostgreSQL.

  1. Table

    A table presents the data as a table composed of rows and columns and is used to see the details and compare the values.
 

Common questions for PostgreSQL

What are the LeadsBridge IPs that need to be whitelisted?

To connect your PostgreSQL database you should whitelist LeadsBridge IPs, you can find them on the following link: ( Learn more)

How can I add my table database schema?

If you get the following error message: - Undefined table: 7 ERROR: relation “table name” does not exist Means that we were not able to find your table in the default database schema, in order to fix this you should: 1. Go to Integrations and open your PostgreSQL integration setup 2. Type your table database schema inside Database Schema (Optional) 3. Finally, click on Finish to save your changes

Do you need help?

Here some additional resources: