3 ms·
Sounds interesting. Recently, I have been looking for a quick approach to make a clone of a production database for use in staging. The idea to avoid failing m
by wdb 6y ago
Sounds interesting. Recently, I have been looking for a quick approach to make a clone of a production database for use in staging.
The idea to avoid failing migrations by applying against a thin clone of production, as somehow migrations fail in production but work fine in staging. Anyone aware of a quick way to make a clone?
Currently copying a 0.5TB db takes 3 hours while I am dreaming of like minutes.
- aeontech 6y agoLook at pgsync or pgloader https://news.ycombinator.com/item?id=22676112 https://news.ycombinator.com/item?id=22676112 There is also interesting work around using filesystem volume snapshots or clones for database cloning, but that requires infrastructural changes… I think there was a startup around that but I can’t find the name :) https://www.sedlakovi.org/blog/2019/03/fast-postgres-snapshots.html https://www.sedlakovi.org/blog/2019/03/fast-postgres-snapsho...
- wdb 6y agoThank you! Your posts let me know to this product: https://postgres.ai/docs/ https://postgres.ai/docs/ Looks interesting too