How to estimate the size of a PostgreSQL DB to be dumped through pg_dump
A very rough estimate is to compute the size of all tables with:

select pg_size_pretty(sum(pg_table_size(tablename::regclass))) 
from pg_tables 
where schemaname not in ('pg_catalog','information_schema');