Hacker News new | ask | show | jobs
by cowthulhu 894 days ago
Sortof unrelated, I've been looking at moving some data from SQL Server to Postgres, and one of the big reasons is replication. SQL Server replication has been super brittle for me - it's always silently choking, getting desynchronized, or exhibiting weird locking behavior with no indication of the issue until you notice something downstream is broken. It's been tough to test Postgres replication though, since a lot these issues only occur at huge volumes of data. Anyone have any experience with the two they can pass on?
2 comments
staticlibs 894 days ago
> moving some data from SQL Server to Postgres

I don't have any first-hand experience with Postgres replication to share, just, when moving DB from MSSQL, Babelfish extensions for Postgres (https://babelfishpg.org/) may be of interest.

link
cryptonector 894 days ago
PG logical replication is rock solid. One annoyance is that you can't subscribe to a publication but using a different schema name, say.
link