CYBERTEC Logo

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

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

by Granthana Biswas | 09.2019
In my previous post about pgBackRest, we saw how to install and setup pgBackRest and make a backup of a […]

pgBackRest to backup PostgreSQL

by Granthana Biswas | 08.2019
pgBackRest is an open source backup tool for PostgreSQL which offers easy configuration and reliable backups. So if you want […]

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

Verifying PostgreSQL replicas

by CYBERTEC Guest | 10.2017
BY Kaarel Moppel - Although Postgres is a great all-around product that can’t be beaten in price-performance ratio, there’s one […]

pg_basebackup: Creating self-sufficient backups

by Hans-Jürgen Schönig | 12.2016
UPDATED September 2023: If you use transaction log shipping (or Point-In-Time-Recovery) in PostgreSQL to keep your data safe, you surely […]

Managing backup speed with pg_basebackup

by Hans-Jürgen Schönig | 01.2015
pg_basebackup and backup speed: In the past couple of years, replication has been made easier and easier. Setting up streaming […]
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram