pg_basebackup is a simple but powerful utility provided by PostgreSQL to create consistent online backups at the filesystem level. Backups created with this command contain the actual database files, so you do not need to restore such backups. You can simply unzip the backup files and copy them to the database data directory.
In this video, we'll walk through the process of creating backups using the pg_basebackup utility and learn about the various options.
0:00 Start
0:40 Create tablespaces and backup user
5:00 Create and restore a database cluster without using compression
11:35 Create and restore a database cluster using compression
17:57 The end
#postgres #postgresql #pg_basebackup #backup #restore