PostgreSQL

Connect your advanced object-relational databases.

Overview

PostgreSQL is a powerful, open-source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

Advanced Data Types

Support for JSONB, arrays, and custom types out of the box.

ACID Compliant

Strict transactional integrity and concurrency control.

Configuration

1. Prerequisites

   Generate your PostgreSQL connection URI. You will need your host, port, database name, user, and password.

2. Configure

   Update your Arivu integration configuration:

   .env

   POSTGRES_URI="postgresql://username:password@localhost:5432/my_database"
   
3. Test Connection

   Click the Test Connection button in the dashboard. If the indicator turns green, your database is securely linked.

For production deployments, carefully restrict connection pooling variables (like max_connections) to avoid database locking.