I think I’d been running discourse incorrectly on my local machine. I used a bitnami virtual machine image and it exports and imports fine. The issue I’m having now is that the DB dump from the bitnami machine gives me an:
[2014-03-09 18:37:31] psql:/var/www/discourse/tmp/restores/default/2014-03-09-183730/dump.sql:10: ERROR: unrecognized configuration parameter "lock_timeout"
When trying to use it as a backup for the digital ocean machine.
Which is, I think, because the postgres version on the digital ocean machine is older than the postgres version used on the bitnami virtual machine.
I’ve tried to upgrade postgres on the docker container but haven’t been successful yet.
UPDATE: Just deleting the
lock_timeout line from the dump.sql and recompressing seems to work fine. It imported into postges 9.2 with no problems.