postgres=# SELECT pg_size_pretty( pg_database_size( 'soft' ) );
 pg_size_pretty
----------------
 2524 MB
(1 row)

pg_dump -x -O -U postgres -h localhost soft > db_soft.sql