crunchy-proxy
patroni
Our great sponsors
| crunchy-proxy | patroni | |
|---|---|---|
| 2 | 14 | |
| 391 | 5,311 | |
| 0.3% | 2.6% | |
| 0.0 | 8.5 | |
| over 1 year ago | 7 days ago | |
| Go | Python | |
| Apache License 2.0 | MIT License |
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.
crunchy-proxy
-
GCP Cloud SQL Migration without outage?
This is why I always recommend using a postgres proxy so you can point it to different database servers as you stand them up. AWS does this by default but GCP doesn’t yet, so you have to have your own Postgres proxy (e.g https://github.com/CrunchyData/crunchy-proxy) or move to an HA Postgres setup like Patroni that has streaming replication (https://github.com/zalando/patroni).
patroni
- Any self hostable postgres clustering, replication and fail over system?
-
GCP Cloud SQL Migration without outage?
This is why I always recommend using a postgres proxy so you can point it to different database servers as you stand them up. AWS does this by default but GCP doesn’t yet, so you have to have your own Postgres proxy (e.g https://github.com/CrunchyData/crunchy-proxy) or move to an HA Postgres setup like Patroni that has streaming replication (https://github.com/zalando/patroni).
- PostgreSQL 14 Released
- Vitess 11
-
How can I check the load of the PostgreSQL container?
Want a tool for increasing the durability of your DB? I suggest running postgres via systemd, or failing that, start-stop-daemon. To get even more robust, look in to something like setting up pgbouncer in front of haproxy in front of a set of read-only replica PG instances running in either logical or streaming replication. To get even MORE robust, I suggest Patroni for high-availability PG.
-
PostgreSQL High availability
see here - https://github.com/zalando/patroni
What are some alternatives?
pg_auto_failover - Postgres extension and service for automated failover and high-availability
stolon - PostgreSQL cloud native High Availability and more.
Grafana - The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.
go-pg - Golang ORM with focus on PostgreSQL features and performance
stolon-chart - Kubernetes Helm chart to deploy HA Postgresql cluster based on Stolon
postgresql_cluster - PostgreSQL High-Availability Cluster (based on "Patroni" and DCS "etcd" or "consul"). Automating with Ansible.
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
pgvector - Open-source vector similarity search for Postgres
nagios-plugins - 450+ AWS, Hadoop, Cloud, Kafka, Docker, Elasticsearch, RabbitMQ, Redis, HBase, Solr, Cassandra, ZooKeeper, HDFS, Yarn, Hive, Presto, Drill, Impala, Consul, Spark, Jenkins, Travis CI, Git, MySQL, Linux, DNS, Whois, SSL Certs, Yum Security Updates, Kubernetes, Cloudera etc...
xo - Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server
postgrest - REST API for any Postgres database