Verify your knowledge

• What is the difference between a logical and physical backup?

  A logical backup, also known as a “dump,” is a backup that interacts directly with the database and its running transactions. A physical backup, also known as a “hot backup,” is a copy of the underlying filesystem and the WALs so that the last known clear state of the database can be restored. See the Introducing types of backups and restores section for more detail.

• What is the difference between pg_dump and pg_dumpall?

  The pg_dump command is used to dump a single database, while pg_dumpall dumps all the intra-database objects (e.g., the users) and then performs a pg_dump against every database in the cluster. See the Dumping a whole cluster section for more details.

• What is the COPY command?

  The COPY command is a PostgreSQL-specific statement aimed at bulk-loading or extracting data. It is often used as a way to dump...