sopho docsPostgreSQL
Connect to PostgreSQL databases
PostgreSQL is a powerful, open source relational database. Sopho supports connecting to PostgreSQL databases for performing analytics. More details about PostgreSQL can be found at PostgreSQL.
Connection Details
When configuring a PostgreSQL connection, you will need the following details:
| Field | Description |
|---|---|
| Host | The hostname or IP address of your PostgreSQL server (e.g. localhost or db.example.com) |
| Port | The port number, typically 5432 for PostgreSQL |
| Database | The name of the database to connect to |
| Username | Your PostgreSQL username. Prefer a user that has only read permission. |
| Password | Your PostgreSQL password |
| Schema | Optional. The schema to use (defaults to public) |