• vapeloki@lemmy.world
    link
    fedilink
    English
    arrow-up
    6
    arrow-down
    1
    ·
    1 year ago

    Use a postgresql operator for that.

    How many postgresql databases without replication and backup if have seen … and 90% of then contained critical data.

    If you really need to run the db inside containers, never by hand.

    And as a full time postgresql dba: NEVER run your production databases inside k8s

      • andrew@lemmy.stuart.fun
        link
        fedilink
        English
        arrow-up
        7
        arrow-down
        1
        ·
        edit-2
        1 year ago

        Because dogma. There are tons of places running production postgres, and indeed many other stateful services, in Kubernetes.

        Edit because presumably GP downvoted me for contradicting them, since I’ve personally overseen this in production at Fortune 100 companies and unicorn startups alike:

        https://dok.community/

        https://github.com/zalando/postgres-operator

        And plenty of YouTube videos from various kubecons and CloudNativeCons. Kubernetes is a runtime and provides plenty of primitives for safely running stateful workloads even better than otherwise possible. Anyone who says otherwise hasn’t bothered directly learning enough about the possibilities and is likely citing oft-quoted dogma that dates back to the earliest days of k8s and was questionable even then.

      • andrew@lemmy.stuart.fun
        link
        fedilink
        English
        arrow-up
        1
        ·
        1 year ago

        Generally if someone tells you to never do something, even if they’re a supposed authority, and they don’t offer reasoning, it’s probably better to investigate further.

      • jpfreely
        link
        fedilink
        English
        arrow-up
        1
        ·
        1 year ago

        Accidentally deleted. It said “why not?”