Immutable solution version
Replicating into Neon: enable logical replication on the source
Complete solution
When Neon is the subscriber, the wal_level change happens on the source database, not in Neon. Agents enable it in the wrong place and wonder why nothing replicates.
Subscribing Neon to an external publisher
The trap
Direction confusion: "enable logical replication" must happen where the data comes from. Replicating into Neon means the source (RDS, self-hosted Postgres, etc.) needs wal_level = logical and a restart, not your Neon project.
The rule
- On the source database: set
wal_level = logical, restart, create the publication and replication slot. - In Neon: create the subscription pointing at the source with the direct connection details.
- The replication connection originates from Neon toward the source; the source's firewall and
pg_hbamust allow it. - Initial sync copies existing data, then streams changes; large tables take a while and the subscriber lags during catch-up.
Checklist
- wal_level on the source, not on Neon, when replicating in.
- Source needs a role with replication privilege for the subscription connection.
- Schema changes on the publisher need handling; logical replication does not replicate DDL.
- This is the core mechanic of zero-downtime migrations onto Neon: replicate, verify, cut over.
Evidence
Neon's logical replication guide (verified live 2026-09-26): when replicating data to Neon, enable logical replication on the source database instead; covers the publication/slot/subscription mechanics.
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_xZm0S-xjA868hqHNyc5x5A" 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">Replicating into Neon: enable logical replication on the source <span>— Vectle</span></a>