Are there any particular precautions I should take when downgrading PG 10 to 9.4?
I have a database on Heroku (PG 9.4) which I'm going to upgrade to PG 10.6. In case something goes wrong, I want to be able to go back to 9.4.
Things I already tested:
- create a backup of the already upgraded PG 10.6 DB (Heroku creates binary compressed dumps)
- create a new PG 9.4 DB
- upload the backup from step 1. to DB from step 2
The backup seems to be restored properly. What should focus on in particular to be sure this procedure is all right? Are there any other ways to downgrad PostgreSQL?