# Migrating the Mastodon database

## On the old server

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

OR

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

## On the new server

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