For thirty years, the answer to “how do I get the DDL for this object?” in PostgreSQL has been: shell out to pg_dump -s and grep. Every tool that has ever needed to reconstruct an object definition — migration tools, schema diff utilities,…
The archiver only runs when a WAL segment is complete. On a busy database that happens constantly; on a quiet one it might not happen for hours or days. archive_timeout exists to prevent the resulting “our database has been accepting…

Hello everyone, here comes a series of my annual posts about the Chicago Postgres Conference, and what I am most excited about. And I want to start with the training sessions we offer. All three training sessions are presented by my…
PgBackRest Is Dead Yesterday the maintainer of PgBackRest, David Steele, published the NOTICE OF OBSOLESCENCE. For further information please read the blog post pgBackRest is dead. Now what? by Lætitia Avrot. She also points to how to go…