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

# PostgreSQL

> Connect your advanced object-relational databases.

<img src="https://mintcdn.com/arivu/piekGGEpY74vFGfF/images/postgres.png?fit=max&auto=format&n=piekGGEpY74vFGfF&q=85&s=140a216014ab8f2b6086f5ad5b6c1d48" alt="PostgreSQL Integration" width="1919" height="908" data-path="images/postgres.png" />

## 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.

<CardGroup cols={2}>
  <Card title="Advanced Data Types" icon="layer-group">
    Support for JSONB, arrays, and custom types out of the box.
  </Card>

  <Card title="ACID Compliant" icon="shield-halved">
    Strict transactional integrity and concurrency control.
  </Card>
</CardGroup>

## Configuration

<Steps>
  <Step title="Prerequisites">
    Generate your PostgreSQL connection URI. You will need your host, port, database name, user, and password.
  </Step>

  <Step title="Configure">
    Update your Arivu integration configuration:

    <CodeGroup>
      ```bash .env theme={null}
      POSTGRES_URI="postgresql://username:password@localhost:5432/my_database"
      ```
    </CodeGroup>
  </Step>

  <Step title="Test Connection">
    Click the **Test Connection** button in the dashboard. If the indicator turns green, your database is securely linked.
  </Step>
</Steps>

<Warning>For production deployments, carefully restrict connection pooling variables (like `max_connections`) to avoid database locking.</Warning>