Skip to content
This repository was archived by the owner on Apr 26, 2024. It is now read-only.
This repository was archived by the owner on Apr 26, 2024. It is now read-only.

check postgres sequences for validity on startup  #7938

@richvdh

Description

@richvdh

in the last two weeks, I've seen two people who have migrated their databases to a new postgres instance and forgotten to copy the sequence generators. At best, this causes confusing errors; at worst, it could lead to corruption.

To save people from shooting themselves in the foot, we could check at startup that there are no rows in the table with IDs above the next number in the sequence, and refuse to start if so.

Metadata

Metadata

Assignees

No one assigned

    Labels

    T-EnhancementNew features, changes in functionality, improvements in performance, or user-facing enhancements.Z-Help-WantedWe know exactly how to fix this issue, and would be grateful for any contributionz-p2(Deprecated Label)

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions