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

I used to run a bunch of Postgres nodes at a similar scale. The most painful parts (by far) were restoring to a new node and major version upgrades.

Any tricks you used for those parts?



> were restoring to a new node

Zfs send / recv or replication.

> I used to run a bunch of Postgres nodes at a similar scale. The most painful parts (by far) were restoring to a new node and major version upgrades. Any tricks you used for those parts?

Replication makes this pretty painless :)


So run a replica? Is there more literature on that?





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

Search: