postgresql db backup and pump into bz2

gistfile1.sh

pg_dump -Unrcrm -h 192.168.x.x --exclude-table=public.foo --exclude-table=public.bar  dbname | bzip2 -c > ~/file.bz2


bzip2 -d db.sql.bz2 |psql test test




SELECT relname, reltuples, relpages * 8 / 1024 AS "MB" FROM pg_class ORDER BY relpages DESC;