postgres
wal-g
Our great sponsors
postgres | wal-g | |
---|---|---|
29 | 13 | |
2,081 | 3,038 | |
1.6% | 3.9% | |
7.8 | 9.0 | |
2 months ago | 6 days ago | |
Shell | Go | |
MIT License | GNU General Public License v3.0 or later |
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.
postgres
- How to Escape a Container
-
Problem with Postgres container configuration?
EDIT: Somehow i managed to fix it right now (I struggled with this problem yesterday for hours). This github issue have helped: https://github.com/docker-library/postgres/issues/537 If anyone runs into this problem, those are crucial instructions that helped me: docker system prune docker-compose up --force-recreate --build --remove-orphans --always-recreate-deps --renew-anon-volumes
- PostgreSQL 16 Beta 1 Released!
-
PyPI new user and new project registrations temporarily suspended
Tragedy of the commons - only need a few actors to ruin it all for us. Almost all distributors face this problem, from Docker Hub to PyPI. This also reminded me of official Postgres Docker image running a cryptominer in the background [1]
[1] - https://github.com/docker-library/postgres/issues/770
- [Docker] Point d’entrée Docker-initdb.d Postgres
-
Nix Turns 20. What the Hell Is It?
If you open the dockerfile of the desired container, you can determine exactly how and what was built. If not satisfied, you can always build your own container with the right postgresql build flags.
-
archive_command not being executed?
Ok according to The Dockerfile, postgres is running in /var/lib/postgresql/data so you will need enter the container and look at the log files in /var/lib/postgresql/data/pg_log/
-
How do I create a docker image for postgres with nix?
I got started on trying to make a basic postgres image but I can't seem to figure out how to include a shell script in the same folder as my nix file (fetched from https://github.com/docker-library/postgres/blob/master/docker-entrypoint.sh and to be modified once I get it working) into the docker image as an entrypoint
- Postgres on docker works without a shell perfectly but fails when run via shell
-
What exactly is VOLUME used for inside the dockerfile?
See example here : https://github.com/docker-library/postgres/issues/601
wal-g
- WAL-G 3.0.0 – fast disaster recovery for Postgres
-
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.
- WAL-G 2.0: backup and restore for database in the cloud
- Script to take PostgreSQL backups
-
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...
- WAL-G 1.1 released: better disaster recovery for PG, MySQL, MongoDB, MS SQL
-
Automate pg_basebackup in linux
Have a look at barman, pgBackrest or for maybe WAL-G or WAL-E
- WAL-G 1.0: unified backup tool for PostgreSQL, MySQL, SQL Server, MongoDB, Redis
What are some alternatives?
pgBackRest - Reliable PostgreSQL Backup & Restore
spilo - Highly available elephant herd: HA PostgreSQL cluster using Docker
wal-e - Continuous Archiving for Postgres
checkmk - Checkmk - Best-in-class infrastructure & application monitoring
docker-postgres-wale - Postgres docker container with WALE-E installed
kanban-board - Single-click full-stack application (Postgres, Spring Boot & Angular) using Docker Compose
citus-failover - Worker failover support for PostgreSQL Citus extension using pg_auto_failover.
MeshCentral - A complete web-based remote monitoring and management web site. Once setup you can install agents and perform remote desktop session to devices on the local network or over the Internet.
gobackup - 🗄 CLI tool for backup your databases, files to cloud storages in schedully.
deck-chores - A job scheduler for Docker containers, configured via labels.