Tagged Questions

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 ...
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: ...
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 ...
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 ...
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` ...
12
votes
3answers
6k views

Heroku “psql: FATAL: remaining connection slots are reserved for non-replication superuser connections”

I'm developing an app on Heroku with a Postgresql backend. Periodically, I get this error message when trying to access the database, both from the CLI and from loading a page on the server: psql: ...
1
vote
1answer
943 views

Errors in evolutions on Heroku

I tried pushing some evolutions to Heroku: 2012-08-30T10:58:00+00:00 heroku[slugc]: Slug compilation finished 2012-08-30T10:58:02+00:00 heroku[web.1]: Starting process with command `target/start ...
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 ...
10
votes
2answers
2k views

Rails 3.1. Heroku PGError: operator does not exist: character varying = integer

Having a little trouble fixing an error. All works great on local machine. On PG, heroku is the error. Here are the logs : ←[32m2012-01-09T19:52:24+00:00 app[web.1]:←[0m ...
3
votes
2answers
932 views

Heroku PostgreSQL GROUP_BY error in Rails app

I've got a rails app that works fine in development (SQLite) but is throwing lots of errors when I've deployed it via Heroku, which uses PostgreSQL I gather. the error message getting returned: ...
9
votes
1answer
2k views

On Heroku, Cedar, with Unicorn: Getting ActiveRecord::StatementInvalid: PGError: SSL SYSCALL error: EOF detected

Heroku support says this has to do with their version of libssl on shared databases, but we've encountered it on a project that's on a dedicated database, too. Basically this error happens every so ...
45
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 ...
7
votes
5answers
2k views

Deploying Django to Heroku (Psycopg2 Error)

So I'm following the getting started guide from heroku with django. However when I run this command: heroku run python manage.py syncdb I get this error psycopg2.OperationalError: could not ...
5
votes
3answers
5k views

heroku db:pull not working

heroku db:pull postgresql://root:@localhost/db_name After this command display this message /usr/lib/ruby/gems/1.8/gems/rest-client-1.6.1/lib/restclient/abstract_response.rb:50: warning: ...
8
votes
2answers
5k views

how to connect to postgresql using url

I had asked an earlier question which did not get any replies. Basically I get an error invalid database url when I try to do heroku db:push So I figured I can try explicitly providing the ...

1 2 3 4 5 6
15 30 50 per page