pg_resetwal: When to reset the WAL in PostgreSQL
How to use pg_resetwal - know the risks - When should you use this powerful tool of last resort to reset WAL? Find out now.
Dealing with streaming replication conflicts in PostgreSQL
by
Laurenz Albe |
11.2020 Streaming replication in PostgreSQL is a well-established master-slave replication technique. It is simple to set up, stable and performs […]
recovery.conf is gone in PostgreSQL v12
by
Laurenz Albe |
12.2019 The biggest change in PostgreSQL v12 from the viewpoint of backward compatibility is that recovery.conf has been absorbed into […]
Never lose a PostgreSQL transaction with pg_receivewal
by
Laurenz Albe |
10.2019 “Durability”, the D of ACID, demands that a committed database transaction remains committed, no matter what. For normal […]
Remote Backup and Restore with pgBackRest
How to setup remote backup servers with pgBackRest, and how a full and incremental backup is performed and restored.
"Exclusive backup" method is deprecated - what now?
by
Laurenz Albe |
02.2019 UPDATE 12.07.2022: The “exclusive backup” method of calling pg_start_backup('label') before backup and pg_stop_backup() afterwards has been removed in PostgreSQL […]
