Following commands also useful to take backup and restore of simple (not contains large objects) postgresql database.
pg_dump mydb > db.out
To restore database
psql -d database -f db.out
Save 15% on Instant Deploy Bare-Metal Servers in 26 Global Markets with Coupon Code: EdgeSave