Downgrading PostgreSQL 10 to 9.4
1
vote
3
answers
15015
views
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:
1. create a backup of the already upgraded PG 10.6 DB (Heroku creates binary compressed dumps)
2. create a new PG 9.4 DB
3. 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?
Asked by pmichna
(323 rep)
Dec 14, 2018, 11:46 AM
Last activity: Oct 30, 2019, 05:41 PM
Last activity: Oct 30, 2019, 05:41 PM