Logical backup makes a copy of the data in the database by dumping the content of each table, as well as object definitions for that same database (such as schemas, tables, indexes, views, privileges, triggers, and constraints).
Hot logical backups of one database
How to do it…
The command to do this is simple. The following is an example of doing this when using a database called pgbench:
pg_dump -F c pgbench > dumpfile
Alternatively, you can use the following command:
pg_dump -F c -f dumpfile pgbench
Finally, we note that you can also run pg_dump via the pgAdmin 4 GUI, as shown in the following screenshot:
