Fatal error when restoring PostGreSQL DB from dump: undefined function system_run_automated_cron I'm trying to simply install Drupal 7.8 on PostGreSQL 9.1, backup the DB, and then restore from it ... nothing else, just to test out backing up my sites, but the site will not come back up!

Here are my steps: 


install Drupal &amp; get through configuration to the "you're done" screen
dump the DB (pg_dump > file.sql)
drop the DB (dropdb)
create a new DB with the same info (createdb)
restore the DB (psql &lt; file.sql)


No steps in between (except when I've tried to avoid the error by putting the site into maintenance mode and/or clear the cache). No adding content, no nuthin'! 

But when I access my site, I get the following error message: 

[22-Nov-2011 17:07:44] PHP Notice:  unserialize() [&lt;a href='function.unserialize'&gt;function.unserialize&lt;/a&gt;]: Error at offset 0 of 1009 bytes in /Applications/MAMP/htdocs/drupal-postgres/includes/cache.inc on line 405
[22-Nov-2011 17:07:44] PHP Notice:  unserialize() [&lt;a href='function.unserialize'&gt;function.unserialize&lt;/a&gt;]: Error at offset 0 of 38585 bytes in /Applications/MAMP/htdocs/drupal-postgres/includes/cache.inc on line 405
[22-Nov-2011 17:07:44] PHP Warning:  Invalid argument supplied for foreach() in /Applications/MAMP/htdocs/drupal-postgres/includes/module.inc on line 185
[22-Nov-2011 17:07:44] PHP Warning:  array_keys() expects parameter 1 to be array, null given in /Applications/MAMP/htdocs/drupal-postgres/includes/module.inc on line 89
[22-Nov-2011 17:07:44] PHP Notice:  unserialize() [&lt;a href='function.unserialize'&gt;function.unserialize&lt;/a&gt;]: Error at offset 0 of 38585 bytes in /Applications/MAMP/htdocs/drupal-postgres/includes/cache.inc on line 405
[22-Nov-2011 17:07:44] PHP Warning:  Invalid argument supplied for foreach() in /Applications/MAMP/htdocs/drupal-postgres/includes/module.inc on line 185
[22-Nov-2011 17:07:44] PHP Warning:  array_keys() expects parameter 1 to be array, null given in /Applications/MAMP/htdocs/drupal-postgres/includes/module.inc on line 89
[22-Nov-2011 17:07:44] PHP Fatal error:  Call to undefined function system_run_automated_cron() in /Applications/MAMP/htdocs/drupal-postgres/includes/common.inc on line 2573


Anyone have any thoughts? This CAN'T be this hard!

Thanks a million!
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.