Fatal error when restoring PostGreSQL DB from dump: undefined function system_run_automated_cron
After looking into this a bunch, I just decided to move the DB to MySQL. I hated to have to do it, but support for sql-dump in drush is limited to MySQL, and Backup and Migrate is as well. Kills me to have to run two DB servers (all my other applications use PostGres), but desperate times call for desperate measures. 

I would hope some day that these modules would support PostGres. As Drupal supports both, so should the modules. 

Some notes to others when using Backup and Migrate and Backup and Migrate Files


File ownership travels with the files, so I've had to "chown apache" files that get moved
It looks like the Temporary Directory setting is stored as a machine-specific folder, so be sure to update this on the destination machine
Clear the cache on the destination machine. I had a case where a tpl.php file wasn't being used until I did this.