PostgreSQL

PostgreSQL, also known as Postgres, is a powerful and feature-rich open-source relational database management system (RDBMS).

It is widely regarded for its reliability, scalability, and extensive capabilities. Designed to handle large volumes of structured and semi-structured data, PostgreSQL follows the relational database model and ensures data integrity through ACID compliance.

You can use PostgreSQL as a destination in Weld to load data from various sources, transform it, and store it in a PostgreSQL database. This allows you to centralize your data, perform analytics, and generate insights from your data.

---

Setup Guide

1. Fill in the required fields

   Host: The hostname of your PostgreSQL server.
   Port: The port number of your PostgreSQL server.
   Database: The name of the database you want to connect to.
   User: The username to connect to the database.
   Password: The password for the user.

2. Extra options

• Use SSL: Enable SSL connection to the database.

• Connect through an SSH tunnel: Enable SSH tunneling to connect to the database. If you enable this option, you need to provide the following details:
  • SSH Host: The hostname of the SSH server.
  • SSH User: The username to connect to the SSH server.
  • SSH Port: The port number of the SSH server.
  • Public Key: Use this key to authorize the SSH connection.