中文 English Français Русский Español العربية

Christophe Pettus: All Your GUCs in a Row: restore_command

Planet PostgreSQL2026-10-28 09:000 views

PostgreSQL's `restore_command` asks for WAL segments one at a time until the command fails—and that failure marks the archive's end, whether it's real or not. (I consult on PostgreSQL through PGX Inc..)

Source：https://postgr.es/p/9Ae

My favorites

PreviousNikolay Samokhvalov: Dump/restore done. Now what?NextVadim Yatsenko: Read-Your-Writes at the Proxy: LSN Session Consistency for PolarDB

Postgres LISTEN/NOTIFY vs Redis Pub/Sub: Latency, Write Cost and Failure Cases, Tested

Cross-posted from my blog. The original, with any updates, lives on fabwaseem.com . If you already run Postgres, you can

0dev.to Node

LlamaIndex Workflows vs LangGraph: Event-Driven Architecture and Async State Overhead Showdown

LlamaIndex Workflows and LangGraph represent the two dominant paradigms for orchestrating complex agentic swarms: pure e

0dev.to Programming

Rider and Databases: Lesser-Known IDE Features That Save Time

Most developers work with databases through dedicated tools: some prefer SQL Server Management Studio (SSMS), others go

0dev.to Database

KivaDB v2: What's Coming and How You Can Contribute

We're excited to announce that development for KivaDB v2 is officially underway! In this post, we'll share what we're pl

0dev.to Database

Your LLM cost log says $0.00. The invoice says $1,320.

You log what each LLM call costs, right next to the request, in a DECIMAL(10,2) column like every other amount of money

0dev.to Database

SQLite in Production: A Practical Setup with Litestream Backups

SQLite often gets dismissed as a toy database, which surprises the many useful applications quietly running on it. For a

0dev.to Database

Christophe Pettus: All Your GUCs in a Row: restore_command

Related posts

Postgres LISTEN/NOTIFY vs Redis Pub/Sub: Latency, Write Cost and Failure Cases, Tested

LlamaIndex Workflows vs LangGraph: Event-Driven Architecture and Async State Overhead Showdown

Rider and Databases: Lesser-Known IDE Features That Save Time

KivaDB v2: What's Coming and How You Can Contribute

Your LLM cost log says $0.00. The invoice says $1,320.

SQLite in Production: A Practical Setup with Litestream Backups