I gave this a try, however, the pg:upgrade command won't work for me. In my setup, I've got an existing master that's running postgresql 9.0.7, and I did:
heroku addons:add heroku-postgresql:zilla --follow MASTER_URL # my master is a zilla as well
heroku pg:wait # waits until the new slave is caught up in commits
heroku maintenance:on
heroku pg:upgrade SLAVE_URL
When I run the upgrade command, I get:
! There were problems upgrading HEROKU_POSTGRESQL_ONYX
! database must be a newer follower. Please create and upgrade a new follower.
Can you open a support ticket or email me directly at harold@heroku.com? I'd like some information on your app and database to troubleshoot this in the backend.
Hi there,
I gave this a try, however, the pg:upgrade command won't work for me. In my setup, I've got an existing master that's running postgresql 9.0.7, and I did:
heroku addons:add heroku-postgresql:zilla --follow MASTER_URL # my master is a zilla as well heroku pg:wait # waits until the new slave is caught up in commits heroku maintenance:on heroku pg:upgrade SLAVE_URL
When I run the upgrade command, I get:
! There were problems upgrading HEROKU_POSTGRESQL_ONYX ! database must be a newer follower. Please create and upgrade a new follower.