1 comments

  • sacs0ni5 days ago
    I built this to have a dedicated wire-protocol client for postgres logical replication. General-purpose SQL clients either don&#x27;t implement the replication protocol at all, or bury it behind abstractions designed for other use cases. Replication has a bit different mechanics - it&#x27;s a stateful binary stream requiring LSN tracking, standby heartbeats, and feedback to prevent WAL bloat. Bolting that onto a query-focused client has its own challenges.<p>This is just the transport - raw XLogData frames and LSNs. Use pg_replicate, as an example, if you need &quot;replicate to BigQuery.&quot; Use this if you&#x27;re building replication infrastructure.<p>What it does:<p>- Explicit LSN control - start&#x2F;stop at specific WAL positions for deterministic recovery<p>- Automatic standby feedback - no more forgotten heartbeats filling your disk with WAL<p>- Bounded channels - backpressure propagates to Postgres naturally<p>- Pure Rust, no libpq<p>What it doesn&#x27;t do: pgoutput decoding (intentionally). That belongs in a higher layer. Simplest way of using this:<p>while let Some(event) = client.recv().await? { match event { ReplicationEvent::XLogData { wal_end, data, .. } =&gt; { process(&amp;data); client.update_applied_lsn(wal_end); } _ =&gt; {} } }
    • nkmnz1 hour ago
      &gt; Use pg_replicate, as an example, if you need &quot;replicate to BigQuery.&quot; Use this if you&#x27;re building replication infrastructure.<p>Would I use this if I host my own postgres and want to use replication for „real time backups“ into a hot standby?
      • radimm59 minutes ago
        Not OP - but definitely no. In such a case use just physical or - if you have special use case - logical replication that’s built in.
        • sacs0ni42 minutes ago
          I agree. pgwire-replication is useful when you need to build a customized and closely controlled pipeline. In fact, it will give you the first part of handling the data (reading from the source), you still need to implement the rest yourself.
    • malodyets2 days ago
      I learned about this tonight when Claude Code picked up your library for my application that uses logical replication. Looking forward to putting it through its paces.
      • sacs0ni2 days ago
        nice! would appreciate any feedback.