Installed via Docker, but imported a vBulletin database from inside the development environment (using git clone … → vagrant up → vagrant ssh → ruby script/import_scripts/vbulletin.rb etc.). Inside vagrant I then took a database dump using:
pg_dump -xOf ./discourse-backup.sql -n public discourse_development
Then copied this dump to my production discourse install and did inside psql:
drop schema public cascade;
create schema public;
…
Then on the command line
sudo -u postgres psql -f /shared/discourse-backup.sql discourse
Noticed that the gravatar paths are all wrong as well. Since the vBulletin import took ~8 hours (200 000 posts), I’m reluctant to start over. Can the email-path be edited inside the database (couldn’t find anything doing a simply ‘grep’ on the dump)?