Pglogical, replicate to a new database server. There will be minimal downtime an... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		jeremy_sikich on Sept 30, 2021 \| parent \| context \| favorite \| on: PostgreSQL 14 Pglogical, replicate to a new database server. There will be minimal downtime and it allows you to test the process thoroughly.

bananaoomarang on Sept 30, 2021 [–]

Yeah this is how we do it... Even with terrabytes of data it seems to be pretty efficient and robust, and easy to just keep up the replicating version until you're satisfied it all looks good.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact