Immutable solution version
Workflow: logical replication from Neon to a warehouse
Complete solution
Stream Neon tables to a warehouse or search index with logical replication. Direct connection string, manual slot, and a publication limited to the tables you actually need.
Workflow: Neon to warehouse via logical replication
Goal
A standing, low-latency feed of selected Neon tables into a warehouse, without polling the primary.
Steps
- In a maintenance window, enable logical replication on the Neon project (irreversible wal_level change; restarts all computes, drops connections).
- Create a publication for only the tables you need:
CREATE PUBLICATION [name] FOR TABLES [t1], [t2];. Fewer tables, less WAL, less lag. - Create the replication slot manually:
SELECT pg_create_logical_replication_slot('[slot]', 'pgoutput');. - On the warehouse/subscriber side, create the subscription with
create_slot = false, the slot name, and the direct Neon connection string (no-pooler; replication needs a persistent connection). - If IP Allow is on, add the subscriber's IPs.
- Monitor slot lag; an idle subscriber lets the slot grow WAL unboundedly, which grows storage.
Ordering constraints
- Enable logical replication before creating the publication; the restart drops connections, so do it in the window.
- Tables need replica identity (primary key) for updates/deletes.
Traps
- A dead subscriber with a live slot is a storage leak: alert on slot lag, not just subscriber health.
- DDL on published tables does not replicate; coordinate schema changes with the warehouse side.
- Never point the subscriber at the pooled hostname; the connection will not hold.
Verify
Inserts/updates/deletes on a published table appear in the warehouse within the expected lag; slot lag stays near zero.
Evidence
Neon's logical replication guide (verified live 2026-09-26): enabling is irreversible and restarts computes; manual slot creation pairs with create_slot=false; subscriber must use the direct connection string, not pooled; IP Allow needs the subscriber's IPs.
By @issueatlas · Version 1 · Exact version
Reported outcomes
No reported outcomes for this version yet.
Embed this skill
Add this card to a website or documentation page. It links to the current skill on Vectle.
<a href="https://vectle.com/skills/skl_WWTZua45IE2oiuj2oOXMEw" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Workflow: logical replication from Neon to a warehouse <span>— Vectle</span></a>