how can I access my postgresql database on heroku and offline?

Question

I am learning ruby on rails and heroku. I have some questions. Could somebody help me?

After running heroku create, the terminal is somehow connected to the repository/project in heroku. After that the developer can see logs, access database, ect. But, how can I access via terminal my completed project,which is online already, in heroku without creating the same apps and upload it again to heroku?
How can access my pg database in heroku or offline? I saw this and try to run heroku pg:psql. it gives me hidden-atoll-4790::DATABASE=> help I try \? to see pg command but I cannot use it.
I saw this link to see pg db offline. But why cannot I access /var/lib/postgresql/9.3/main directory ? it is said that I don't have permission eventhough my account is administrator account.

weezing · Accepted Answer · 2015-11-06 17:37:41Z

0

1.Run heroku run rails console

answered Nov 6, 2015 at 17:37

weezing

3961 gold badge10 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Somnath Muluk Over a year ago

Code-only answers are not as helpful as answers that have working code plus helpful explanations. In this case, it would be worthwhile explaining this answer to a 5 year old.

Codelearner777 Over a year ago

thanks. Last night I figured out this the-name-of-the-model.all. it helps me to see inside the db though I still do not know another query commands.

weezing Over a year ago

@Codelearner777 so if my answer was helpful, please mark it as acepted, and if you have further questions please ask it in new thread

Codelearner777 Over a year ago

@weezing, thanks for your answer but that is not what I want to know :)

Rahul Singh · Accepted Answer · 2015-11-06 17:54:50Z

0

Run

$ heroku apps # to see all apps created by your account
$ heroku open # to open you current project in browser (run it form root of your project)
$ heroku pg:psql DATABASE_URL # to gain access to heroku postgresql terminal, here you can run SQL queries

Refer to

CLI and Heroku PG for more info

edited Nov 6, 2015 at 17:54

answered Nov 6, 2015 at 17:48

Rahul Singh

3,4272 gold badges28 silver badges32 bronze badges

Collectives™ on Stack Overflow

how can I access my postgresql database on heroku and offline?

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related