Skip to content

Latest commit

 

History

History
11 lines (7 loc) · 632 Bytes

File metadata and controls

11 lines (7 loc) · 632 Bytes

PostgreSQL

Regular backups of PostgreSQL databases are crucial for preserving valuable data. Although the process is relatively straightforward, it is essential to grasp the underlying methods and assumptions involved.

There are three distinct methods for backing up PostgreSQL data, each with its own advantages and disadvantages:

  1. SQL dump
  2. File-system level backup
  3. Continuous archiving

In the subsequent sections, we will discuss each approach individually, examining their respective strengths and weaknesses.