angristan/psql_migration.md

## psql_migration.md

      
    Raw
  

              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