Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I am trying to use a free heroku postgres instance to use as my test database, but I am running into a problem as the first step seems to be for minitest to drop the database, which heroku postgres doesn't allow instead it allows to purge the database I think.

action@clinio2-13639:~/workspace/clinio(master*)$ rake                                                                                                                                                           
    rake aborted!                                                                                                                                                                                                    
    FATAL:  permission denied for database "postgres"                                                                                                                                                                
    DETAIL:  User does not have CONNECT privilege.
    ......
    Tasks: TOP => db:test:load => db:test:purge                                                                                                                                                                      
    (See full trace by running task with --trace)

not sure how to get past this error. And my dev environment I dont have root privlidges so I cant set up a local postgres instance which would obviously be ideal. Any help would be much appreciated!

share|improve this question
add comment (requires an account with 50 reputation)

1 Answer

up vote 0 down vote

Unfortunately, I think you just really need root privileges in a development environment. Heroku is pretty locked down, so it's not ideal for testing. Here are some options:

  • Find or buy a cheap machine to use for web development. If you're familiar with Linux (or are open to becoming more familiar), you have a free operating system to install that works really well with rails development. I do all my webdev work in Linux and recommend Linux Mint for newcomers.
  • Check out Nitrous.io. I haven't used it, but it looks interesting and it seems to have a free option for in-browser web development. I'm not sure if it would provide the kind of environment you need and am not in any way affiliated with the service.
share|improve this answer
1  
Hi chris thanks for your input but intact nitrous.io is the dev environment I am using unfortunately no root access. I think I'll just have to move to developing on my local machine if I can't work it through with their support! Thanks for your help though – mattclar Jul 10 at 2:47
Good to know! Not having root access is kind of a deal-breaker, so thanks for the heads up on Nitrous. I just gave you a +1 for answering MY question. :-) – Chris Fritz Jul 10 at 3:15
add comment (requires an account with 50 reputation)

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.