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 the custom format, is lightly compressed by default. Compression can be removed or made more aggressive.
The pg_dump utility runs by executing SQL statements against ...