4 ms·

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

by sa46 2y ago

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?

Eikon 2y ago
> 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 :)
- wg0 2y ago
  So run a replica? Is there more literature on that?
  - Eikon 2y ago
    > So run a replica? Basically, yes. https://www.postgresql.org/docs/current/runtime-config-replication.html https://www.postgresql.org/docs/current/runtime-config-repli...