Tagged Questions

1
vote
1answer
28 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
40 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
53 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
248 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
365 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
43 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
69 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
52 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
38 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
49 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
109 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
174 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| ...