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

Описание: 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