Exploring Logical Backup in PostgreSQL
Backup and Recovery is one of the most essential jobs for every database administrator. We all know the importance of the backups for the databases. Here I am not going to write its importance, rather about the different types of backup tools available for the PostgreSQL server. In PostgreSQL, we can perform both logical and physical backups as same as MySQL Logical Backups (Text Backup) Physical Backups (Copying data files + Redo Log files) In this blog, we are going to compare the tools in PostgreSQL which performs logical backups. In our previous post, we had made a similar kind of comparison of logical backup tools available for the MySQL database( Mysqldump vs Mysqlpump vs Mydumper ). Logical Backups:- Logical Backups are simple and the textual representation of the data in the databases. It contains insert queries and create statements to reproduce the data in the destination. In PostgreSQL, we are having two logical backup tools Pg_dump Pg_d