PostgreSQL Error While Schema Fetching

Issue

While fetching schemas from the source, one of the following errors appears:

• No schemas provided in the patch
• Error while schema fetching

Environment

All PostgreSQL connectors

Resolution

To resolve this issue, do the following:

1. Ensure the Fivetran user has the necessary SELECT permissions on the required schemas and tables.

2. Verify that no firewall or proxy restrictions are preventing us from accessing the relevant database.

3. Confirm that data is available in the source.

4. If the process takes longer than 30 minutes, pause and resume your connection:

   i. In Fivetran, go to your PostgreSQL connection page.

   ii. In the top right, set the ENABLED toggle to OFF, then back to ON.

If the issue persists, contact our support team to limit schema fetching to only tables with SELECT privileges, which can help prevent memory overload.

Cause

This issue occurs when we attempt to retrieve column metadata for all tables in a database that contains a large number of tables. This can lead to high memory usage and overload, especially when including tables without SELECT privileges.