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

Published: 25 September 2021
on channel: mynotesoracledba
5,395
51

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


Watch video PostgreSQL Logical Backup-Pg-dump| How to take backup using pg_dump online without registration, duration hours minute second in high quality. This video was added by user mynotesoracledba 25 September 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,395 once and liked it 51 people.