Hot logical backups of one database
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).
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, note that you can also run pg_dump via the pgAdmin 4 GUI, as shown in the following screenshot:
Figure 11.2 – Using the pgAdmin 4 GUI
How it works…
The pg_dump utility produces a single output file. This output file can use the split command to separate the file into multiple pieces if required.
The pg_dump archive file, also known ...
