Tagged Questions
24
votes
7answers
16k views
How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
Running a Ruby on Rails (RoR) app or Ruby code which uses the ActiveRecord framework, you get the error message:
Please install the postgresql adapter:
gem install
...
9
votes
14answers
7k views
Can't install pg gem on Windows
I've got 2 Ruby versions: 1.8.7 and 1.9.2 and PostgreSQL 8.3. I cant install pg gem on any of them. Getting this error:
C:/Development/Ruby187/bin/ruby.exe extconf.rb
checking for pg_config... yes
...
2
votes
3answers
542 views
Rails 3.1 with PostgreSQL: GROUP BY must be used in an aggregate function
I am trying to load the latest 10 Arts grouped by the user_id and ordered by created_at. This works fine with SqlLite and MySQL, but gives an error on my new PostgreSQL database.
Art.all(:order => ...
9
votes
3answers
2k views
Rails Resque workers fail with PGError: server closed the connection unexpectedly
I have site running rails application and resque workers running in production mode, on Ubuntu 9.10, Rails 2.3.4, ruby-ee 2010.01, PostgreSQL 8.4.2
Workers constantly raised errors: PGError: server ...
2
votes
1answer
1k views
Installing PL/Ruby for PostgreSQL
This is to enable the development of postgres functions with embedded ruby code,
but I have been unable to build it.
As advised by
...
4
votes
4answers
1k views
Adding Table Columns to a Group by clause - Ruby on Rails - Postgresql
I am trying to use Heroku and apparently Postgresql is a lot more strict than SQL for aggregate functions. When I am pushing to Heroku I am getting an error stating the below.
On another question I ...
2
votes
2answers
455 views
Rails: encoding woes with serialized hashes despite UTF8
I've just updated from ruby 1.9.2 to ruby 1.9.3p0 (2011-10-30 revision 33570). My rails application uses postgresql as its database backend. The system locale is UTF8, as is the database encoding. The ...
1
vote
3answers
88 views
Group by specified column in PostgreSQL
Maybe, this question is a little stupid, but I'm confused.
How to group records by specified column ? :)
Item.group(:category_id)
does't works...
It says:
ActiveRecord::StatementInvalid: ...
0
votes
1answer
59 views
ruby postgreSQL on AMD64
---------------- EDIT ----------------
I've tried what @Duk said, and still nothing work.
After trying a little more, i figured out that the problem isn't on DataMapper.
In fact it's the postgreSQL ...
0
votes
2answers
137 views
Ruby -> PostgreSQL connection with pg_hba.conf set to “ident sameuser” instead of “trust”
I've tried every Google search term I can think of but everything I dig up keeps saying to set local connections to trust in pg_hba.conf (seems like a security hole if anyone locally can log in and ...
0
votes
3answers
923 views
PGError: ERROR: relation “table_name” does not exist
I am trying to push a simple app up to heroku and run:
heroku rake db:migrate
But I get the following error:
rake aborted!
PGError: ERROR: relation "posts" does not exist
: SELECT ...
0
votes
2answers
194 views
Postgres: Error using GROUP BY and ORDER (on heroku)
I am trying to solve my heroku problem which it seems to have problem of
We're sorry, but something went wrong.
We've been notified about this issue and we'll take a look at it shortly.
...
24
votes
7answers
7k views
Pros/Cons of MySQL vs Postgresql for production Ruby on Rails environment?
I will soon be switching from sqlite3 to either postgres or mysql. What should I consider when making this decision? Is mysql more suited for Rails than postgres in some areas and/or vice versa? Or, ...
10
votes
6answers
9k views
Please install the postgresql adapter: `gem install activerecord-postgresql-adapter` [closed]
Possible Duplicate:
How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
I'm trying to get Redmine ...
7
votes
6answers
6k views
Failing installing pg gem, “mkmf.rb can't find header files for ruby” (Mac OSX 10.6.5)
I just upgraded to rails3 and had a bit of a mess with macports/gems/databases to sort out. So I threw out all gems to install them fresh. Everything seems to be ok except for the aquirement of the pg ...
