PostgreSQL
Requirements
Before you connect PostgreSQL to Kaldea, you will need to know your database information:
| Description | Default | |
|---|---|---|
| Host Address | Database server address | |
| Port Number | Database server port | 5432 |
| Database Name | Database name |
If your connection is protected, you might need to add Kaldea’s IP addresses to your whitelist. Read more here
Connect PostgreSQL to Kaldea
Follow these steps to connect your PostgreSQL database to Kaldea.
Step 1
Navigate to Settings > + Add Datasource and select PostgreSQL as source Type*.
Step 2
Fill out the form with the necessary information:
- Name*: Write a display name for your data source
- Host*:
your-database-server-address-here - Port*:
your-database-server-port-here - Database*:
your-database-name-here
System Credential
Kaldea uses this account to synchronize the metadata of customer tables and schedule jobs. It performs queries on system tables and scheduled tables.
- Username*:
your-database-account-here - Password*:
your-database-password-here - The following grant must be allowed for this user’s privileges:
GRANT ALL PRIVILEGES
ON ALL TABLES IN SCHEMA public TO {{your-database-account-here}};
User Default Credential
This account is applied by default when members of your organization query tables in Kaldea.
- Username*:
your-database-account-here - Password*:
your-database-password-here - Set an appropriate account level for your company and add it to the basic user account information.
Step 3 (Optional)
Additional User Account Information
You can register individual user account information for each member by entering the Credential keys for each member. Navigate to Settings>Members>{{User}}>…>Credential key. Once the credentials are registered, the registered credentials will always take precedence.
Troubleshooting
Here’s how to solve some common problems when connecting PostgreSQL.