Example of using pg_dump: pg_dump -F c -U your_username -h some_host.rds.amazonaws.com -d your_db_name