Backups do PostgreSQL com pgdump

O pgdump permite fazer backups de um banco de dados no PostgreSQL

Sobre a section do pgdump

Only dump the named section. The section name can be pre-data, data, or post-data. This option can be specified more than once to select multiple sections. The default is to dump all sections.

The data section contains actual table data, large-object contents, and sequence values. Post-data items include definitions of indexes, triggers, rules, and constraints other than validated check constraints. Pre-data items include all other data definition items.

Em resumo:

Data: Inserts nas tabelas, large-object contents, sequence values.

Post-Data: Indexes, Triggers, Event Triggers, Rules, Primary Keys, Unique Keys

Pre-Data: Check Constraints, Tables, Schemas, Views, Functions,

Documentação oficial
https://www.postgresql.org/docs/current/app-pgdump.html