PostgreSQL Logical Backup-Pg-dump| How to take backup using pg_dump

preview_player
Показать описание
Backup methods /Types:

1.Logical Backup - With respect to Structure/content of DB

2.Physical Backup - with respect to files of the DB



based on your business requirement build up stragercy


The first one we are going to see Logical backup

What is a logical backup?

here We are going to take the backup strcuture i.e Let us consider we have DB here we are taking the backup structure It similar like sequence,trigger,table..etc

the logical backup has been taken output as dump it contains structure and content i.e We are extracting the data and stucture from db stored into yourdump files.

#postgresql #logicalbackup #backupandrestore #pg_dump
Рекомендации по теме
Комментарии
Автор

How to take backup with 100 rows from each table?

mastimasti