Database Reference
In-Depth Information
If the command doesn't return anything, it means that the follower database has been cre-
ated and synchronized with your main database.
Next, you need to promote the follower database to the main database. For this, you first
need to perform the unfollow action and after that, promote the database. Through the
heroku pg:info
command, you can see the information on your main database and
follower database:
$ heroku pg:info --app your-app-name
=== HEROKU_POSTGRESQL_CHARCOAL_URL (DATABASE_URL)
Plan: Standard Yanari
Status: Available
...
Followers: HEROKU_POSTGRESQL_GOLD
...
=== HEROKU_POSTGRESQL_GOLD_URL
Plan: Standard 2
Status: Available
...
Following: HEROKU_POSTGRESQL_CHARCOAL
Behind By: 0 commits
...
Tip
The
Behind By
field informs us that the follower database is outdated from the main
database by zero commits.
Now, you need to unfollow the main database using the following command:
$ heroku pg:unfollow HEROKU_POSTGRESQL_GOLD_URL --app
your-app-name
The following command promotes it as the main database:
$ heroku pg:promote HEROKU_POSTGRESQL_GOLD_URL --app
your-app-name
Promoting HEROKU_POSTGRESQL_GOLD_URL to DATABASE_URL...
done
