agentm / agentm/project-m36

Create a plan for persistent storage upgrades

Ouverte
#24 5 commentaires 2 réactions 1 personne assignée Réclamée par @agentm Voir sur GitHub
Langage dominant
Haskell
Étoiles
952
Forks
50
Métriques de merge des PR
Aucune PR mergée en 30 j

Description

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 (?)

Guide de contribution

Aucun guide de contribution indexé pour ce dépôt

Évaluation

Cette issue n'a pas encore été évaluée.

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.