wal-g
spilo
Our great sponsors
| wal-g | spilo | |
|---|---|---|
| 13 | 2 | |
| 3,040 | 1,302 | |
| 3.9% | 3.0% | |
| 9.0 | 6.9 | |
| 5 days ago | 9 days ago | |
| Go | Python | |
| GNU General Public License v3.0 or later | Apache License 2.0 |
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.
wal-g
-
Introducing Read Replicas
Streaming replication minimizes replication lag, while file-based log shipping provides a fallback. For file-based log shipping, we use our existing Point In Time Recovery (PITR) infrastructure. We regularly archive files from the primary using WAL-G, an open source archival and restoration tool, and ship the WAL files to S3.
-
Go 1.18 (Go with generics) no blocking issues left
While everyone fears some new spiral of complexity, it's nice
https://github.com/wal-g/wal-g/pull/1186
Add a few type constraints, throw out a few type casts along with the error handling
- Optimizing Postgres Queries at Scale
-
A rough proposal for sum types in Go, from a Rust compiler engineer
When it's occasionally useful return (type, err), but generally the two results are distinct so there's no need to return two results in the general case when one suffices
Indeed, I recently updated some code to return a relevant value in the error case: https://github.com/wal-g/wal-g/pull/1143/files#diff-d896e5d5...
-
Automate pg_basebackup in linux
Have a look at barman, pgBackrest or for maybe WAL-G or WAL-E
-
Backup Postgresql Docker
I think what you are looking for is https://github.com/wal-g/wal-g. It is the more modern version of wal-e.
spilo
-
Why PostgreSQL High Availability Matters and How to Achieve It
one of the solutions which made it pretty simple for us to run postgresql in a ha environment (mostly in k8s, but works standalone as well) is zalandos patroni: https://github.com/zalando/patroni it's really solid and worked for us for a few years already.
or for k8s their operator: https://github.com/zalando/postgres-operator (docker image: https://github.com/zalando/spilo) we've also tried other operators which were easier to get started, but they failed miserably (crunchyrolls operator is basically based on the zalando one)
- Backup Postgresql Docker
What are some alternatives?
pgBackRest - Reliable PostgreSQL Backup & Restore
wal-e - Continuous Archiving for Postgres
postgres - Docker Official Image packaging for Postgres
docker-postgres-wale - Postgres docker container with WALE-E installed
citus-failover - Worker failover support for PostgreSQL Citus extension using pg_auto_failover.
gobackup - 🗄 CLI tool for backup your databases, files to cloud storages in schedully.
Backup - Easy full stack backup operations on UNIX-like systems.
Barman - Barman - Backup and Recovery Manager for PostgreSQL
netbox-docker - 🐳 Docker Image of NetBox