Explore our sites

Stack Exchange
tour help careers 2.0

Tagged Questions

-1
votes
0answers
46 views

Heroku keeps telling me my application fails

So I am trying to push my site to heroku for the first time and some things have gone wrong. First was the postgres DB stuff so I added the gem for pg in the production group but it continues to say ...
-1
votes
0answers
29 views

Deploying to Heroku issues Rails 3.2

So i had an app that i initially developed in SQLITE and converted over to POSTGRESQL and it works fine locally. When I try to deploy to Heroku my web dynos crash when I try to visit my application. ...
1
vote
2answers
60 views

Postgresql with Rails 4.0.1 — not running on localhost:3000 or deploying to Heroku

When I try to run my sample Rails 4.0.1 app on my localhost:3000, I get this error: PG:: ConnectionsBad FATAL: role "myapp" does not exist. I'm running on Maverick OSX and using Ruby 2.0. I created ...
2
votes
0answers
86 views

gem install dm-postgres-adapter build error

i'm trying to build dm-postgres-adapter but get this error. sudo gem install dm-postgres-adapter Building native extensions. This could take a while... ERROR: Error installing dm-postgres-adapter: ...
0
votes
0answers
53 views

Postgres DEV en. not working, but heroku is

PG::UndefinedTable: ERROR: relation "users" does not exist LINE 4: WHERE a.attrelid = '"users"'::regclass ^ : SELECT a.attname, ...
5
votes
0answers
229 views

Heroku + Sidekiq: ActiveRecord::StatementInvalid: PG::UnableToSend: SSL SYSCALL error: EOF detected

Hi we are running on Heroku's Cedar stack with Unicorn and Sidekiq. We intermittently get the following errors BurnThis ActiveRecord::StatementInvalid: PG::UnableToSend: SSL SYSCALL error: EOF ...
0
votes
0answers
25 views

Fix GroupingError or Deploy somewhere else?

A wonderful user wrote this slice of code for me. @ribbits = Ribbit.where('user_id IN (?)', buddies_ids).order('created_at DESC').group(:user_id) I'm running twitter Rails 3.2, and this lets me ...
1
vote
0answers
42 views

Why does explicitly passing a hash allow heroku postgres to set primary keys as I want it to

Spent the past hour running migrate on heroku wondering why the following migrate doesn't set the primary key from id to what I want it to be: class CreateProducts < ActiveRecord::Migration def ...
1
vote
1answer
37 views

Restarting Heroku database

I'm runnning a rails app on heroku with a postgres database hosted by Amazon. I tried a migration that would never end (over 40 minutes) and ran it a few too many times. Now I have 20 connections open ...
1
vote
0answers
44 views

Search rails app for integer on heroku

I am adding a search bar to my rails app. It works perfectly to find text, but I also want to search my "date" field, which is an integer. I'm sure there is a simple answer to this, but I have looked ...
0
votes
0answers
64 views

Heroku PG restore fails on password

I have created a Rails and an uploaded it to Heroku. The PG database is empty and I would like to use pgAdmin3 to restore it from a local backup. I can access the Heroku PG database via pgAdmin just ...
1
vote
0answers
267 views

PG:InsufficientPrivilege: ERROR when trying to make an INSERT on stage database

Im using heroku and postgres. Local is working fine but whenever the user (any user) performs an INSERT on stage it crashes. This is the message i get: PG:InsufficientPrivilege: ERROR: permission ...
2
votes
0answers
443 views

Heroku Postgres Out of Memory error

My Rails app has been running fine until this morning. I tried restarting the app and here is the error i'm getting before i even hit a page. Out of Memory error on the Postgres connection! I can ...
0
votes
1answer
56 views

Heroku Postgres Database

I'm completely confuse about Heroku Postgres Plan. Please help. When I check for PG info, using: heroku pg:info It's showing: === HEROKU_POSTGRESQL_BRONZE_URL Plan: Basic Status: ...
0
votes
0answers
78 views

Rails 4 Heroku Mysql to Postgres Dump Pending Migrations

I've converted my mysql db to postgres. I'm used the following to import it to the db: heroku pgbackups:restore database 'http://app.com' --app This creates all the tables and imports the data. ...
0
votes
0answers
56 views

RoR Application built using spree works fine in local not in heroku

I have an ROR application thats about an year old so it uses older versions of multiple spree dependencies but i have ensured that it works perfectly and as expected without any dependency issues in ...
0
votes
1answer
41 views

Extracting API into another heroku app. Best practice

I'm planning on extracting some API endpoints from a Rails app hosted on Heroku that uses Postgres into a new Heroku app. What is the advisable way to do this? Share the database with the 2nd app ...
0
votes
0answers
52 views

Rails code working with sqlite but fails on heroku with postgres

Can any one suggest why the following query might be raising error: TypeError: can't dump anonymous class Class: INSERT INTO "emails" ("content", "created_at", "email_from", "email_to", "filter_id", ...
0
votes
1answer
114 views

Use pgbackups dump to selectively restore to heroku db

I have a dump filed generated from pgbackups and I want to use some of the data in it to populate a new database on heroku. It's not a simple restore. I want to use the -t option from pg_restore and ...
0
votes
1answer
177 views

Why does PostgreSQL rolls back my INSERT statement?

I have a model where I am storing stuff. When the value of a boolean attribute (action_type) is false, then PostgreSQL rolls back the INSERT query for some reason. create_table :process_flows do |t| ...