Back to Materialize

Troubleshooting

doc/user/content/ingest-data/postgres/troubleshooting.md

1231.1 KB
Original Source

This section contains troubleshooting guides for specific errors you may encounter when using PostgreSQL sources in Materialize. These guides focus on errors that are unique to the PostgreSQL replication workflow, including issues with replication slots, WAL management, and other CDC-specific scenarios.

For general data ingestion troubleshooting that applies to all source types, see the main Troubleshooting guide. For answers to common questions about PostgreSQL sources, see the FAQ.

Troubleshooting guides

GuideDescription
Slot overcompactedResolve errors when PostgreSQL removes WAL data before Materialize can read it
Connection ClosedResolve unexpected networking connection terminations between Materialize and PostgreSQL
Replication slot is activeResolve errors when Materialize attempts to use a replication slot that is already in use by another active connection