Pull and Push heroku pg database
Pull and Push heroku pg database. 1- gem install pg 2- gem install heroku taps sequel #login to local pg database 3- sudo su - postgres 4- heroku pg:pull HEROKU_POSTGRESQL_MAGENTA mylocaldb --app HerokuAppName HEROKU_POSTGRESQL_MAGENTA=> to know HEROKU_POSTGRESQL_MAGENTA run the following command ' heroku pg:psql' or we can direct access the herku pg database by this command. HEROKU_POSTGRESQL_MAGENTA=> this would be in the following format 'hci-tool:: COBALT' mylocaldb=> your databse name; HerokuAppName=> Your heroku app url PULL example=> heroku pg:pull hci-tool::COBALT hci-tool-new --confirm git@ heroku .com:hci-tool.git PUSH example=> heroku pg:pull hci-tool-new hci-tool::COBALT --confirm git@ heroku .com:hci-tool.git