# Substitute whatever tool you use to dump your db
pg_dump -Udbadmin dbname | zip dbname-backup -

##</code><code>##

unzip -c dbname-backup -