---
title: Connect Postgres Database to Infoveave
description: Learn how to connect and configure PostgreSQL in Infoveave to query relational data from Postgres databases for dashboards and reports.
---

import { MediaPlayerComponent } from "../../../../../components/video-player";
import RunScript from "../../../../../components/RunScript.astro";
import { Steps } from '@astrojs/starlight/components';

# Postgres

<MediaPlayerComponent
  video="PostgresConnection.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 4,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 4,
    "end": 7,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new datasource connection."
  },
  {
    "start": 7,
    "end": 9,
    "text": "Select Postgres Connection",
    "description": "In the 'New Connection' window, scroll down to the 'Database' section and click on 'Postgres' to establish a connection to a Postgres database."
  },
  {
    "start": 9,
    "end": 17,
    "text": "Configure Postgres Details",
    "description": "In the 'New Postgres Connection' dialog box, enter the connection name. Keep the 'Port' as '5432' and the 'Server' as 'localhost.' Provide the 'Username,' enter the corresponding 'Password,' and set the 'Database'."
  },
  {
    "start": 17,
    "end": 20,
    "text": "Validate Postgres Connection",
    "description": "Click the 'Validate' button to confirm that the provided Postgres server details and credentials are correct and that Infoveave can successfully connect to the database."
  },
  {
    "start": 20,
    "end": 25,
    "text": "Save Postgres Connection",
    "description": "After the connection validates successfully, click the 'Save' button to finalize and add the 'Postgres Infoveave' connection to your list of available connections."
  }
]

}
  poster="/images/introduction-poster.png"
  posterText="Creating Postgres Connection"
  client:load
/>

Postgres connection helps to connect Postgres database for accessing and managing your relational data directly from Infoveave.

## Adding a Postgres Connection

To create a new Postgres connection:

<Steps>
1. Go to **Administration** > **Connections**
2. Click **New Connection** and select **Postgres** from the available connectors
3. In the **New Postgres Connection** form, provide the required configuration details
</Steps>

## Connection Parameters

When setting up a Postgres connection, you need to provide the following details:

| Field | Description |
|-------|-------------|
| **Name** | A unique name to identify your Postgres connection |
| **Server** | The Postgres Server host address or instance name |
| **Port** | The Postgres Server port (default: 5432) |
| **Username** | Your Postgres authentication username |
| **Password** | Your Postgres authentication password |
| **Database** | The specific database name to connect to |
| **Schema** | The database schema (optional) |
| **Attributes** | Additional connection attributes and parameters |

## Steps to Validate and Save

<Steps>
1. After configuring your Postgres connection parameters, click **Validate** to verify the connection
2. If validation succeeds, click **Save** to store the connection
3. You can now use Postgres Server as a datasource in your Infoveave workspace
</Steps>

## Example Use Cases

With a Postgres connection configured, you can:

- Query and analyze relational data directly from Postgres databases
- Create real-time dashboards with data from multiple Postgres tables
- Build automated workflows that trigger on database changes and events
- Perform complex data joins and transformations using advanced SQL queries
- Leverage Postgres's JSONB capabilities for semi-structured data analysis
- Schedule regular data extracts from Postgres for reporting and analytics
- Integrate Postgres data with other data sources in Infoveave
- Monitor database performance metrics and query optimization
- Set up data synchronization between Postgres and other systems
- Create advanced analytics using Postgres functions and stored procedures
- Generate business intelligence reports from enterprise application data
- Analyze geospatial data using Postgres's PostGIS extension
- Process and visualize time-series data with Postgres's temporal features