Tag: backup and recovery

Get the Newest PostgreSQL Info, Tips & Tricks

Here you can find all blog posts about the Tag: backup and recovery. You can go back to all blog posts or take a look into our other categories & tags.

pg_resetwal: When to reset the WAL in PostgreSQL

by Hans-Jürgen Schönig | 10.2023

pg_resetwal (formerly known as pg_resetxlog) is a command provided by PostgreSQL which allows you to reset the WAL (Write Ahead […]

How To

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 […]

How To

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 […]

News

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 […]

How To

Remote Backup and Restore with pgBackRest

by CYBERTEC Guest | 09.2019

Written by Granthana Biswas In my previous post about pgBackRest, we saw how to install and setup pgBackRest and make […]

How To

"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 […]

How To