Heroku Postgres: Make existing database follower

Question

As recommend by Heroku we keep a follower provisioned so we always have a hot standby available. This is on a lower plan than the main database.

In the last few weeks they have had a number of outages, so we find ourselves making use of the follower:

heroku pg:promote FOLLOWER_URL

Then when the main database is back online we promote this again, which leaves the old follower as an isolated fork.

The question is, it is possible to restore the old follower database back to follower status, and if so what is the command?

In the docs I could only find how to provision a new follower:

heroku addons:add heroku-postgresql:ronin --follow HEROKU_POSTGRESQL_CHARCOAL_URL

To my knowledge this is not possible.

Jesper
– Jesper

2013-09-18 08:30:27 +00:00
Commented Sep 18, 2013 at 8:30 — Jesper
– Jesper, Commented Sep 18, 2013 at 8:30

David Aldridge · Accepted Answer · 2013-09-18 08:35:42Z

3

I don't think that this is possible, and in any case would almost certainly require that the contents of the database be dropped and rebuilt as if it were a completely new follower database.

answered Sep 18, 2013 at 8:35

David Aldridge

52.5k8 gold badges73 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Heroku Postgres: Make existing database follower

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related