Latest Tech News

Stay updated with the latest in technology, AI, cybersecurity, and more

Filtered by: pgstream Clear Filter

Pgstream: Postgres streaming logical replication with DDL changes

pgstream - Postgres replication with DDL changes pgstream is an open source CDC command-line tool and library that offers Postgres replication support with DDL changes to any provided target. Features Schema change tracking and replication of DDL changes Support for multiple out of the box targets Elasticsearch/OpenSearch Webhooks PostgreSQL Initial and on demand PostgreSQL snapshots (for when you don't need continuous replication) Column value transformations (anonymise your data on the g

Speeding up PostgreSQL dump/restore snapshots

The last few pgstream releases have focused on optimizing snapshot performance, specifically for PostgreSQL targets. In this blog post, we’ll walk through the key improvements we made, share the lessons we learnt, and explain how they led to significant performance gains. But first, some context! What is pgstream? pgstream is an open source CDC(Change Data Capture) tool and library that offers Postgres replication support with DDL changes. Some of its key features include: Replication of DDL