ansible-role-postgresql-ha
Install and configure PostgreSQL cluster managed with repmgr. Add dependencies, extensions, databases and users. (by fidanf)
cloudnative-pg
CloudNativePG is a Kubernetes operator that covers the full lifecycle of a PostgreSQL database cluster with a primary/standby architecture, using native streaming replication (by cloudnative-pg)
Our great sponsors
- Onboard AI - Learn any GitHub repo in 59 seconds
- Revelo Payroll - Free Global Payroll designed for tech teams
- SonarQube - Static code analysis for 29 languages.
- InfluxDB - Collect and Analyze Billions of Data Points in Real Time
| ansible-role-postgresql-ha | cloudnative-pg | |
|---|---|---|
| 1 | 8 | |
| 16 | 2,184 | |
| - | 21.3% | |
| 10.0 | 0.0 | |
| 10 months ago | 3 days ago | |
| Jinja | Go | |
| MIT License | Apache License 2.0 |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
ansible-role-postgresql-ha
Posts with mentions or reviews of ansible-role-postgresql-ha.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-01-25.
-
Any self hostable postgres, clustering, replication and fail over system?
For example https://github.com/fidanf/ansible-role-postgresql-ha
cloudnative-pg
Posts with mentions or reviews of cloudnative-pg.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-08-19.
- Deploying Postgres on Kubernetes in production
-
Kubernetes postgres backups
We already had backup and recovery using object storage, but we are working to support VolumeSnapshots taking care to properly shut down the instance first! This awesome PR is laying the foundation for it, it's adding a subcommand to our kubectl plugin to manually perform a backup using VolumeSnapshots and adding support for restoring a Cluster from it, next step will be adding it to the ScheduledBackup/Backup resources too!
-
What are you using to run Postgres?
This has a bunch of side-effects that break usual expectations around scheduling. For instance, cluster scale-down (for maintenance etc.) is blocked unless a specific taint has been added to each database pod. In addition, if the underlying node does fail, your cluster will be stuck in fail-over state until you manually delete the underlying pods. I think there are definitely other gotchas around this decision to use a custom controller but I have only tested this on GKE.
-
Can you create a Postgres Deployment with multiple replicas consuming to the same PV?
Another option would be https://github.com/cloudnative-pg/cloudnative-pg I got to see this talk at Kubecon last month that might be of use to you too -> https://www.youtube.com/watch?v=99uSJXkKpeI That talk is run in part by EDB, who are the company behind CloudNativePG, they are talking about their commercial offering, but the principle is the same.
-
How do people read CRDs?
Following another post on this sub, I was checking out the Github project and landed on this 2864 lined CRD https://github.com/cloudnative-pg/cloudnative-pg/blob/main/config/crd/bases/postgresql.cnpg.io_clusters.yaml. How are sane people reading these files?
-
Managing PostgreSQL databases as K8s resources
**NOTE**: I am a maintainer of CloudNativePG.
- Pgo: The Postgres operator from crunchy data
What are some alternatives?
When comparing ansible-role-postgresql-ha and cloudnative-pg you can also consider the following projects:
postgres-operator - Postgres operator creates and manages PostgreSQL clusters running in Kubernetes
postgres-operator - Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service.
postgres - 🐘 Run PostgreSQL in Kubernetes
kubegres - Kubegres is a Kubernetes operator allowing to deploy one or many clusters of PostgreSql instances and manage databases replication, failover and backup.
percona-postgresql-operator - Percona Operator for PostgreSQL
crd-to-sample-yaml - Generate a sample YAML file from a CRD
sbom-operator - Catalogue all images of a Kubernetes cluster to multiple targets with Syft
pgBackRest - Reliable PostgreSQL Backup & Restore
kubectl-evict - A kubectl plugin to evict pods
argo-helm - ArgoProj Helm Charts