agentm / agentm/project-m36

Create a plan for persistent storage upgrades

Aperta
#24 5 commenti 2 reazioni 1 assegnatario Rivendicata da @agentm Vedi su GitHub
Lingua principale
Haskell
Stelle
952
Fork
50
Metriche di merge delle PR
Nessuna PR unita negli ultimi 30g

Descrizione

Upgrading postgresql releases over an existing installation has been painful for years due to:
- machine-specific representations stored on disk (big-/little-endian, floating point)
- the inability for new postgresql releases to read the older formats
- extension upgrades

These pain points are somewhat alleviated by pg_upgrade since rewriting the entire database is often untenable for ever-increasingly large data sets.

To ensure that Project:M36 doesn't hit this same hurdle, we should plan on making upgrades to binary releases as smooth as possible.

Considerations:
- minimize downtime
- minimize steps (automate away upgrade process)
- don't rewrite the database by default
- do allow the user to choose to rewrite the database in case the user wishes to continue to use the older release (pg_upgrade's hard link or copy dichotomy)
- live, in-place upgrades (?)

Guida per i contributori

Nessuna guida per i contributori indicizzata per questo repository

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.