Tagged Questions

47
votes
6answers
7k views

Quickest way to find out heroku database size

What is the quickest way to find out the current size of my shared database in Heroku?
44
votes
8answers
13k views

How do you easily change from SQLite to PostgreSQL in Rails

I have a rails app that's databases are in SQLite (The dev and production). Since I am moving to heroku, I want to convert my database to PostgreSQL (I think that's how to spell it). Anyways, I heard ...
43
votes
11answers
28k views

How do you write a case insensitive query for both MySQL and Postgres?

I'm running a MySQL database locally for development, but deploying to Heroku which uses Postgres. Heroku handles almost everything, but my case-insensitive Like statements become case sensitive. I ...
36
votes
3answers
13k views

Rails 3.1 - Pushing to Heroku - Errors installing postgres adapter?

I just upgraded to Rails 3.1 and the first app i've tried to deploy to Heroku has encountered a problem relating to Postgres adapter. I'm able to push the app to heroku but then when i try to migrate ...
30
votes
9answers
13k views

postgreSQL group by different from mysql?

I've been migrating some of my mySQL queries to postgreSQL to use Heroku... most of my queries work fine, but I keep having a similar recurring error when I use group by: ERROR: column "XYZ" must ...
27
votes
4answers
5k views

Connect to a heroku database with pgadmin

I would like to manage my heroku database with pgadmin client. By now, I've been doing this with psql. When I use data from heroku pg:credentials to connect de DB using pgadmin, I obtain: An error ...
26
votes
10answers
10k views

Heroku Postgres Error: PGError: ERROR: relation “organizations” does not exist (ActiveRecord::StatementInvalid)

I'm having a problem deploying my Rails app to Heroku, where this error is thrown when trying to access the app: PGError: ERROR: relation "organizations" does not exist ...
25
votes
10answers
4k views

Error when pushing data to Heroku: time zone displacement out of range

I run the following command to push the contents of my local database to Heroku: heroku db:push --app my-app From my home computer this works flawlessly but from my work computer I get this error: ...
21
votes
1answer
9k views

Installing PostgreSQL on Ubuntu for Ruby on Rails

I currently have Ruby on Rails installed via RVM in Ubuntu 12.04. The default database is set up in SQLite3, but I'd like to switch to PostgreSQL for the purposes of pushing to Heroku. How can I ...
18
votes
5answers
4k views

Why does Heroku use Postgresql?

I'm busy porting some MySQL specific code to Postgresql in order to use it with Heroku. Just wondering if there is any specific reason why Heroku went with Postgresql over MySQL? Performance, ...
18
votes
2answers
3k views

How do I change column type in Heroku?

I am trying to rake the db:migrations into my heorku instance and I get an error. The FAQ described my error as below: Cannot change column type Example: PGError: ERROR: column ...
17
votes
4answers
2k views

Heroku database performance experience needed?

We are experiencing some serious scaling challenges for our intelligent search engine/aggregator. Our database holds around 200k objects. From profiling and newrelic it seems most of our troubles may ...
16
votes
3answers
7k views

PGError: ERROR: permission denied for relation

I've recently gone through the database migration process as outlined here: https://devcenter.heroku.com/articles/migrating-from-shared-database-to-heroku-postgres Now I'm seeing a number of errors ...
14
votes
3answers
9k views

Heroku error when launch rails3.1 app missing postgres gem

I am trying to deploy to heroku. Rails 3.1.0.rc4, I get the following error from Heroku logs: Starting process with command: `thin -p 48902 -e production -R /home/heroku_rack/heroku.ru start` ...
14
votes
4answers
3k views

Rails Performance Tuning for Production?

I'm getting close to deploying an application built on Rails 3.1.x and started running some performance tests. After fiddling with ab for a bit, I'm seeing some very discouraging results yielding ...

1 2 3 4 5 … 44
15 30 50 per page