Hot logical backup of one database
Logical backup makes a copy of the data in the database by dumping the content of each table.
How to do it…
The command to do this is simple, as follows:
pg_dump -F c > dumpfile
Or, you can use the following command:
pg_dump –F c –f dumpfile
You can also do this through pgAdmin3, as shown in the following screenshot:
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 as
custom format, is lightly compressed by default. Compression can be removed or made more aggressive. ...
Get PostgreSQL 9 Administration Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
