Dumping and restoring a Postgres DB across environments
It's often very convenient to run a prod DB in a dev environment, either for testing or for ad hoc analysis. Here's how to do it with ssh, pg_dump and pg_restore.
It's often very convenient to run a prod DB in a dev environment, either for testing or for ad hoc analysis. Here's how to do it with ssh, pg_dump and pg_restore.