Creating a backup using the pg_basebackup utility, part 1
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:23 Create a backup user in the database
1:10 We configure access to the database for the backup user in the pg_hba.conf file
1:44 Create a backup without using compression
4:58 Creating a backup using compression
8:09 The end
#postgres #postgresql #pg_basebackup #backup #restore
![Complete online adult ballet center [30 minutes]](https://images.videosashka.com/watch/IgZEpRMQ-cE)
