PostgreSQL database server administration — Backup and Restore Basics (Development / Learning environment)

There are different types of backup and restore for the PostgreSQL database as below —

PostgreSQL Logical Backup SQL dump (or Logical)
PostgreSQL Physical Backup File system-level backup (or Physical)
Continuous archiving (or Point In Time Recovery)

In this article I will go through with Logical backup and physical backup for giving a very good understanding with PostgreSQL…