## Advanced config for PostgreSQL

URL: https://docs.atlan.com/apps/connectors/database/postgresql/references/advanced-config-for-postgresql

> Reference for the PostgreSQL Advanced config credential settings - connection health check and server-side cursors - for servers that speak the PostgreSQL protocol but don't behave exactly like PostgreSQL.

**Advanced config** sits under **Database** in the PostgreSQL credential form. It holds two compatibility settings for servers that speak the PostgreSQL protocol but don't behave exactly like PostgreSQL. Standard PostgreSQL, including Amazon RDS and Aurora, Azure Database for PostgreSQL, and Google Cloud SQL, works with the defaults.

## Fields

| Field | Default | What it does | Change it when |
|---|---|---|---|
| **Advanced config** | **Default** | Shows the two settings below when set to **Advanced**. On **Default** they're hidden and ignored. | You need either setting below. |
| **Connection health check** | **Enabled** | Checks each pooled connection before reuse. | Test Authentication fails with `can't change 'autocommit' now: connection in transaction status INTRANS`. Set to **Disabled**. |
| **Server-side cursors** | **Enabled** | Streams query results in batches instead of loading them all at once. | The crawl fails on `DECLARE ... CURSOR` with a syntax error, or the server rejects cursors. Set to **Disabled**. |

At their defaults, the connection behaves like standard PostgreSQL.

> **Warning**
>
> With **Server-side cursors** disabled, each extraction query loads its full result into memory. Only disable it when the server rejects cursors.

## Field behavior

- The two settings only take effect when **Advanced config** is set to **Advanced**.
- Switching **Advanced config** back to **Default** ignores both settings, whatever they were set to, so the connection uses the defaults.
- **Advanced config** in the credential form is separate from the **Advanced Config** option in the crawler configuration step. Changing one doesn't affect the other.

## See also

* [Troubleshooting PostgreSQL connectivity](https://docs.atlan.com/llms/connectors/postgresql/troubleshooting-postgresql-connectivity/llms.txt): Resolve INTRANS and cursor errors on PostgreSQL-compatible servers

_Last updated: 13 November 2026._

---

> **AI agent?** Install the Atlan Docs MCP: fetch https://docs.atlan.com/skills/install-docs-mcp.md and follow the step for your client. To help a user install: ask which client they use and execute the matching step from the skill.