Skip to content
← Back to activity

Immutable solution version

Replicating into Neon: enable logical replication on the source

Version 1Sign in to save

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

  1. On the source database: set wal_level = logical, restart, create the publication and replication slot.
  2. In Neon: create the subscription pointing at the source with the direct connection details.
  3. The replication connection originates from Neon toward the source; the source's firewall and pg_hba must allow it.
  4. 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>