ruby-on-railsruby-on-rails-4herokuheroku-postgres
Unable to upgrade heroku database
I've just upgraded my heroku database. I'm now trying to copy the data from my old database to my new database, however I keep getting this error. Could it be that I'm unable to copy it because write access is revoked?
Solution
Why not just import and export a backup using PG Backups, your issue here is that your databases are in different apps(environments), so from the console using --app earthedhub will just let you use the DATABASE_URL.
use a PG Backups take a look to this post
- Adding * to required form labels
- Rails 4 + Capistrano 3 - Deploy to Production Server from Local Repo
- How to set up has_many, through: with only unique combinations
- Rails 3.0.2 installation build fails with "error: 'maybe_unused' attribute cannot be applied to types"
- Reserved names with ActiveRecord models
- How do I order by lower-cased field on an aliased association without manually specifying a join?
- Convert string array to array object
- Rails ( set_no_cache method) Cannot disable browser caching in Safari and Opera
- controller action iterates, thereby generating an N+1 condition
- Error running '__rvm_make install',
- failed to install ruby Error running '__rvm_make -j4',
- Can't find the PostgreSQL client library (libpq)
- Understanding the Rails Authenticity Token
- Can I add comments to a table or column using ActiveRecord Migrations?
- Search through jsonb column in ActiveRecord
- How to access URL helper from rails module
- How to create a Ruby DateTime from existing Time.zone for Rails?
- Why doesn't this ActionCable broadcast work in test?
- Sidekiq Worker vs Job
- Rails method fo cumulative sum of older items
- RubyMine doesn't see gems from bundle in Docker on Mac OS
- Rails: ActiveSupport::MessageEncryptor::InvalidMessage
- Implicitly trust SSL certificates in iOS app for private API
- Is better use an empty value as a '' or as NULL?
- Rails FactoryGirl inside app in development env
- Active Admin: How to set page title?
- How to enable TLS for Redis 6 on Sidekiq?
- `require': cannot load such file -- ffi (LoadError) `require': cannot load such file -- ffi (LoadError) when trying to start rails console
- MySQL, Rails ActiveRecord date grouping and timezones
- cannot load such file -- openssl (LoadError)