Hacker News Reader

> Use pg_replicate, as an example, if you need "replicate to BigQuery." Use this if you're building replication infrastructure.

Would I use this if I host my own postgres and want to use replication for „real time backups“ into a hot standby?

View on HN

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.

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.

Reply on news.ycombinator.com