✳flâneur — a map of the web's best reading

Postgres WAL Files and Sequence Numbers | Crunchy Data Blog

crunchydata.com · 1,624 words · saved by 1 readers

High availability production deployment for self-managed PostgreSQL deployed through a Kubernetes Operator. Automated high availability PostgreSQL solutions for traditional self-managed deployments on VMs and traditional infrastructure. Hardened, secure, access controlled PostgreSQL to meet advanced security requirements. Brian Pace The Postgres Write Ahead Log (WAL) is a functional component to the database. WAL makes a lot of key functionality possible, like Point-in-Time-Recovery backups, recovering from an event, streaming replication, and more. From time to time, those deep inside the database will need to work directly with WAL files to diagnose or recover. Recently in working with one of Crunchy Data's customers, I came across a situation where understanding the names and sequence numbers was important. In working with several of my colleauges that commit to the Postgres project, I collected notes on some of the details inside WAL. The goal today to look at the LSN and naming co

Brian Pace Feb 15, 2023 · 7 min read More by this author Latest Articles British Columbia, Time Zones, and Postgres Postgres Serials Should be BIGINT (and How to Migrate) Postgres 18 New Default for Data Checksums and How to Deal with Upgrades PostGIS Performance: Simplification Postgres Scan Types in EXPLAIN Plans Production Postgres Postgres WAL Files and Sequence Numbers Brian Pace Feb 15, 2023 · 7 min read · More by this author The Postgres Write Ahead Log ( WAL ) is a functional component to the database. WAL makes a lot of key functionality possible, like Point-in-Time-Recovery backups ,

Explore this link on the map →

saved by

related reading