Logical backup makes a copy of the data in the database by dumping out the contents of each table.
The command to do this is simple and as follows:
pg_dump -F c > dumpfile or pg_dump F c f dumpfile
You can also do this through pgAdmin3 as shown in the following screenshot:
pg_dump produces a single output file. The output file can use the split(1) command to separate the file into multiple pieces, if required.
pg_dump into custom format is lightly compressed by default. Compression can be removed or made more aggressive.
pg_dump runs by executing SQL statements against the database ...