Postgres pg_dump straight into another database for backup or development

I frequently use a dump of the live database data to test new migrations, new features. I used to pg_dump on the remote live server to a file, then scp it across to my local server, psql it back to life in a new database. I have wondered if it was possible to do it […]