Patroni instead of Non HA Postgres

[bakayolo]

Hey guys,
The stable Posgtres does not have the automatic failover.
We are most likely gonna migrate from Prisma to Hasura. Therefore we need to migrate from Mongodb to Postgres.
Any recommendations on a HA Postgres? I am currently evaluating https://github.com/helm/charts/tree/master/incubator/patroni/

[coco98]

Also, have you thought about using the managed Postgres from the cloud vendor or from compose / aiven? They should have HA options too.

…

On Tue, May 14, 2019 at 12:12 AM, Appréderisse Benjamin < ***@***.***> wrote: Hey guys, The stable Posgtres does not have the automatic failover. We are most likely gonna migrate from Prisma to Hasura. Therefore we need to migrate from Mongodb to Postgres. Any recommendations on a HA Postgres? I am currently evaluating https://github.com/helm/charts/tree/master/incubator/patroni/ — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#6?email_source=notifications&email_token=AABAAWCLT4GKTP2W6YC5IPDPVJQ6PA5CNFSM4HMW6GL2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4GTTBL2A>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AABAAWBSU3HQ4SVTXH54IPDPVJQ6PANCNFSM4HMW6GLQ> .

[bakayolo]

@coco98 nop, we aim to be cloud agnostic and deployable on private DC.
So cloud services are not an option.

[coco98]

👌 makes sense. There’s also crunchydata that you can check out: https://github.com/CrunchyData/postgres-operator

…

On Tue, May 14, 2019 at 12:21 AM, Appréderisse Benjamin < ***@***.***> wrote: @coco98 <https://github.com/coco98> nop, we aim to be cloud agnostic and deployable on private DC. So cloud services are not an option. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#6?email_source=notifications&email_token=AABAAWCI4B4OSJWNVY67A5LPVJR6ZA5CNFSM4HMW6GL2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVKQF3A#issuecomment-492110572>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AABAAWCVG2MENCHI4SD6WZLPVJR6ZANCNFSM4HMW6GLQ> .

[bakayolo]

Thanks, it might be a bit overkilled but I'll have a look. :) 👍

[sachaarbonel]

Hi @bappr, you should take a look to kubedb postgresql