Troubleshooting

View as Markdown

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

Guide	Description
Slot overcompacted	Resolve errors when PostgreSQL removes WAL data before Materialize can read it
Connection Closed	Resolve unexpected networking connection terminations between Materialize and PostgreSQL
Replication slot is active	Resolve errors when Materialize attempts to use a replication slot that is already in use by another active connection