Tagged Questions

1
vote
1answer
50 views

Getting “Unknown primary key for table” while the ID is there

I've been debugging this trange problem of Rails giving me "Unknown primary key for table...", even when the table's ID is there. I've copied the database from one heroku app to another, on the ...
0
votes
2answers
26 views

Problems with syncdb after creating Heroku Django app

I'm setting up a Django app on Heroku using the https://devcenter.heroku.com/articles/django tutorial and I'm running into the below error running heroku run python manage.py syncdb ...
0
votes
0answers
11 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
27 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
34 views

Postgres.app: pg_restore hangs

I'm trying to troubleshoot the pg_restore command on my system. I've installed Postgresapp, and I've included its binaries on my PATH. Commands such as psql and pg_dump appear to work fine, and ...
0
votes
1answer
52 views

Restoring only some tables into Heroku Postgres via heroku pgbackups:restore

According to the heroku docs, the following command restores a pg_dump into a Heroku Postgres Database: heroku pgbackups:restore DATABASE 'https://s3.amazonaws.com/me/items/3H0q/mydb.dump' However, ...
0
votes
1answer
15 views

How to pass filename to Heroku pg:sql command?

I want to load schema from structure.sql file to my Heroku database. On my localhost machine I do as follows and all works just fine, all tables are created: C:\> psql -U postgres -a -d ...
0
votes
1answer
30 views

Rails - Heroku Postgresql SQL Error - Works on Local SQLite - Error “ActiveRecord:Invalid Relation”

Hi here is my ActiveRelation query that works fine on local development environment (SQLite) @table2_items = @table1var.table2_items.find(:all, conditions: ["status1 is ? AND status2 is ? AND ...
1
vote
0answers
34 views

Selecting an object by it's id using django with heroku postgresql

I've got an app running on Heroku with Django, the local DB I use SQLite, but on Heroku the app uses PostgreSQL. I'm having a problem and I've no idea why is happening. Let me explain myself: I ...
0
votes
2answers
68 views

How can I download db from heroku?

I'm using heroku and I want to download the database from my app so I can make some changes in it, I've installed pgbackups, but using heroku pgbackups:url downloads a .dump file How can I make it so ...
1
vote
0answers
109 views

Low Postgres Cache Hit Ratio - data size or something else?

I've just upgraded my Heroku postgres database from the Kappa plan (800MB RAM, postgres 9.1) to the Ronin plan (1.7GB RAM, postgres 9.2), but performance has degraded. Following the guide here, I ...