Mastodon DB migration

psql_migration.md

Migrating the Mastodon database

On the old server

postgres@postgresql:~$ pg_dump -Fc mastodon -f mastodon.dump

OR

postgres@postgresql:~$ pg_dump -Fc mastodon > mastodon.dump

On the new server

postgres=# CREATE USER mastodon;
postgres@postgresql:~$ createdb -T template0 mastodon
postgres@postgresql:~$ pg_restore -n public --no-owner --role=mastodon -d mastodon mastodon.dump