pgreplay

pgreplay reads a PostgreSQL log file (*not* a WAL file), extracts the SQL statements and executes them in the same order and relative time against a PostgreSQL database cluster. (by laurenz)

Pgreplay Alternatives

Similar projects and alternatives to pgreplay

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better pgreplay alternative or higher similarity.

pgreplay reviews and mentions

Posts with mentions or reviews of pgreplay. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-10-20.
  • Versioning data in Postgres? Testing a Git like approach
    9 projects | news.ycombinator.com | 20 Oct 2023
    pgreplay parses not the WAL Write Ahead Log but the log file: https://github.com/laurenz/pgreplay

    From "A PostgreSQL Docker container that automatically upgrades your database" (2023) https://news.ycombinator.com/item?id=36748041 :

    pgkit wraps Postgres PITR backup and recovery:

  • Real Application Testing on 🚀YugabyteDB with 🐘pgreplay
    1 project | dev.to | 3 Oct 2022
    This blog was just to verify that it works with YugabyteDB. Check pgreplay documentation for more, all works the same in YugabyteDB. If you want to capture a workload from connections on multiple database nodes, each one will have their logfile. You can merge them. The Session ID (the 6th field in the csvlog built from start time and backend pid will probably not collide with another one, but you can make it unique by concatenating a node number if you want). The replay connects to one node, but though a HA proxy the connections can be distributed to multiple ones. All depends on what you want to capture and wh you want to replay. Capturing from PostgreSQL and replaying to YugabyteDB is also a good way to check that all works the same without performance regressions.

Stats

Basic pgreplay repo stats
2
203
4.2
7 months ago

laurenz/pgreplay is an open source project licensed under GNU General Public License v3.0 or later which is an OSI approved license.

The primary programming language of pgreplay is C.


Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com