One line command to import prod data to development computer

The pg_dump command runs on your prod server streaming all the data into pg_restore which runs locally

1
ssh user@remote.com pg_dump -Fc --no-acl --no-owner remote_db | pg_restore --verbose --clean --no-acl --no-owner -d localdb

I am currently working on LiveForm which makes setting up contact forms on your website a breeze.