What is the difference between pg_dump and Pg_basebackup?

Question

pg_dump creates a logical backup, that is a series of SQL statements that, when executed, create a new database that is logically like the original one. pg_basebackup creates a physical backup, that is a copy of the files that constitute the database cluster. You have to use recovery to make such a backup consistent. 30 июн. 2020 г.

What is the difference between pg_dump and Pg_dumpall?

Dumping Using pg_dump and pg_dumpall. The pg_dump utility can be used to generate a logical dump of a single database. If you need to include global objects (like uses and tablespaces) or dump multiple databases, use pg_dumpall instead. The output generated by pg_dump is not a traditional “backup”.

What is Pg_basebackup?

pg_basebackup makes an exact copy of the database cluster's files, while making sure the server is put into and out of backup mode automatically. Backups are always taken of the entire database cluster; it is not possible to back up individual databases or database objects.

What is pg_dump used for?

pg_dump is a utility for backing up a PostgreSQL database. It makes consistent backups even if the database is being used concurrently. pg_dump does not block other users accessing the database (readers or writers).

What is pg_dump and Pg_restore?

The pg_restore command takes an archive file created by a pg_dump command and restores the selected PostgreSQL database. When pg_dump is used with one of the non-plain text formats, the restore command will bring the database back.

Expert · Answer