ruby on rails - Heroku: running pg_restore from a local file returns errors -
i trying load test db file store locally (db.sql), using
heroku run pg_restore -d foo db.sql
the error message getting says:
error: must install @ least 1 postgresql-client-<version> package.
i tried sudo apt-get postgresql-client-9.4.1
, , get:
bash: sudo: command not found
and without sudo
, get:
e: invalid operation postgresql-client-9.4.1
you need use locally-installed pg_restore
restore data heroku-hosted database.
i run this:
pg_restore --verbose --clean --no-acl --no-owner -h [host address] -p [port] -u [username] -d [name] [file path]
more info here: postgresql backup , restore commands
Comments
Post a Comment