Pgstream: Postgres Streaming Logical Replication with Ddl Changes

Posted4 months agoActive4 months ago

fenn

77 points

6 comments

github.comTechstory

supportivepositive

Debate

10/100

PostgresReplicationDatabase Management

Key topics

Postgres

Replication

Database Management

Pgstream, an open-source tool for Postgres logical replication with DDL changes, was shared on HN, sparking discussion about its features and potential applications.

Snapshot generated from the HN discussion

Discussion Activity

Light discussion

First comment

Peak period

2-4h

Avg / period

Key moments

01Story posted
Sep 15, 2025 at 8:28 AM EDT
4 months ago
Step 01
02First comment
Sep 15, 2025 at 12:03 PM EDT
4h after posting
Step 02
03Peak activity
2 comments in 2-4h
Hottest window of the conversation
Step 03
04Latest activity
Sep 16, 2025 at 3:55 AM EDT
4 months ago
Step 04

Generating AI Summary...

Analyzing up to 500 comments to identify key contributors and discussion patterns

Discussion (6 comments)

Showing 6 comments

jdc0589

4 months ago

1 reply

I wish this was around 5 or 6 years ago when I was writing a direct native consumer of a logical replication slot, also in Go coincidentally. It's way easier to do natively with Postgres than I'd have guessed, but still a bit of a PITA. I wish I still had access to that code to do a side-by-side.

This looks great by comparison from what I remember though.

gulcin_xata

4 months ago

Thanks for the feedback!

torvald

4 months ago

1 reply

Nice to see tooling like this pop up. At previous company, when we built our, mostly self-hosted, analytics platform, and had devs average on one schama migration per day, we spent so much time dealing with this semi-manually, leading to all kinds of breaking and hiccups downstream. We had something working rather automatically at the end, but it really felt like tooling that should exist for everybody.

gulcin_xata

4 months ago

Ah, thanks for the sharing this insight.

gulcin

4 months ago

We also just released v0.8.1 today. You can read the release blog here, if you're interested: https://xata.io/blog/pgstream-v081-update

tudorg

4 months ago

Great to see pgstream on HN!

Besides DDL changes, pgstream can also do on-the-fly data anonymization and data masking. It can stream to other stores, like Elasticsearch, but the current main focus is on PG to PG replication with DDL changes and anonymization.

We've been using it in Xata to power our `xata clone` functionality, which creates a "staging replica" on the Xata platform, with anonymized data that closely resembles production. Then one gets fast copy-on-write branching from this anonymized staging replica. This is great for creating dev branches and ephemeral environments.

View full discussion on Hacker News

ID: 45248868Type: storyLast synced: 11/20/2025, 3:41:08 PM

Want the full context?

Jump to the original sources

Read the primary article or dive into the live Hacker News thread when you're ready.

Open link View on HN