pg-lock-tracer
A eBPF based lock tracer for the PostgreSQL database (by jnidzwetzki)
wal-e
Continuous Archiving for Postgres (by wal-e)
pg-lock-tracer | wal-e | |
---|---|---|
3 | 7 | |
123 | 3,424 | |
- | 0.0% | |
8.3 | 3.0 | |
10 days ago | 5 months ago | |
Python | Python | |
Apache License 2.0 | BSD 3-clause "New" or "Revised" License |
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.
pg-lock-tracer
Posts with mentions or reviews of pg-lock-tracer.
We have used some of these posts to build our list of alternatives
and similar projects.
wal-e
Posts with mentions or reviews of wal-e.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-09-22.
-
Run PostgreSQL. The Kubernetes Way
See the GitHub: https://github.com/wal-e/wal-e
Unmaintained would’ve made more sense to say, but the maintainer choose the words “obsolete” so I took those. :)
Seems to be obsolete due to a lack of interest and contributions.
-
Are stupid database questions allowed? If a database is backed up only every hour, do we just lose the unbacked up data within the one hour time frame?
I believe the idea originally started with Wal-E project (https://github.com/wal-e/wal-e) since then there were many improvements to it and AWS no doubt has their own proprietary solution.
-
Recovering a PostgreSQL Database After a Hard Drive Failure
Hope this helps someone out there.
https://github.com/wal-e/wal-e
-
Advice for syncing a Postgres database with a TimescaleDB database
Running your own postgres server on AWS is not difficult. You'll want to get familiar with EBS and look into using a tool like wal-e to manage your WAL logs and ensure yuor ability to recover from the various exciting failure modes that Amazon makes available to you.
-
Change Data Capture with Debezium
These read-replicas leveraged WAL segments created by the primary database; however, we didn’t want to bog down the primary database with each replica by reading directly from production. To circumvent this issue, we leverage wal-e, a tool that performs continuous archiving of PostgreSQL WAL files and base backups, and read replicas restored from s3 or gcs versus reading directly from the primary database.
-
Automate pg_basebackup in linux
Have a look at barman, pgBackrest or for maybe WAL-G or WAL-E
-
Backup Postgresql Docker
I am using the following docker image https://github.com/docker-library/postgres. I want the ability to make regular backups to my S3 bucket. PITR is not necessary but a nice to have. I've tried to use https://github.com/wal-e/wal-e but I've not found something that works very well with docker.