# Preferred adapter for PostgreSQL 8.3 on Rails 2.0.2 **URL:** \ **Category:** Rails\ **Created:** [March 31, 2008, 11:09pm UTC](https://www.ruby-forum.com/t/preferred-adapter-for-postgresql-8-3-on-rails-2-0-2/133475 "2008-03-31T23:09:50Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![zakifataya](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/z/c89c15/32.png) [@zakifataya](https://www.ruby-forum.com/u/zakifataya)\ **Post date:** [March 31, 2008, 11:09pm UTC](https://www.ruby-forum.com/t/preferred-adapter-for-postgresql-8-3-on-rails-2-0-2/133475/1 "2008-03-31T23:09:50Z")
What is the preferred Active Record adapter for PostgreSQL 8.3 on Rails 2.0.2 ? Brian A. ---
**Author:** ![zakifataya](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/z/c89c15/32.png) [@zakifataya](https://www.ruby-forum.com/u/zakifataya)\ **Post date:** [October 19, 2008, 2:24pm UTC](https://www.ruby-forum.com/t/preferred-adapter-for-postgresql-8-3-on-rails-2-0-2/133475/2 "2008-10-19T14:24:31Z")
Brian A. wrote: > What is the preferred Active Record adapter for PostgreSQL 8.3 on > Rails 2.0.2 ? > > Brian A. The post is old, but as of today I installed the gem postgres and specified the adapter postgresql in database.yml everything is running smoothly with Rails 2.1.1 If someone has a better setup, please let us know. ---
**Author:** ![zakifataya](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/z/c89c15/32.png) [@zakifataya](https://www.ruby-forum.com/u/zakifataya)\ **Post date:** [October 19, 2008, 2:49pm UTC](https://www.ruby-forum.com/t/preferred-adapter-for-postgresql-8-3-on-rails-2-0-2/133475/3 "2008-10-19T14:49:40Z")
My bad, the gem postgres is no longer maintained since 2006. I am now running with ruby-pg which was last updated on 14th October 2008. ---
**Author:** ![zakifataya](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/z/c89c15/32.png) [@zakifataya](https://www.ruby-forum.com/u/zakifataya)\ **Post date:** [October 19, 2008, 3:00pm UTC](https://www.ruby-forum.com/t/preferred-adapter-for-postgresql-8-3-on-rails-2-0-2/133475/4 "2008-10-19T15:00:14Z")
Fernando P. wrote: > My bad, the gem postgres is no longer maintained since 2006. > > I am now running with ruby-pg which was last updated on 14th October > 2008. Heh. I was just going to mention ruby-pg. I believe that’s the “right” one now. Peace. ---
**Author:** ![zakifataya](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/z/c89c15/32.png) [@zakifataya](https://www.ruby-forum.com/u/zakifataya)\ **Post date:** [October 19, 2008, 5:27pm UTC](https://www.ruby-forum.com/t/preferred-adapter-for-postgresql-8-3-on-rails-2-0-2/133475/5 "2008-10-19T17:27:43Z")
## For some strange reason, if I specify: ## config.gem ‘ruby-pg’ in environment.rb, Rails can’t find the gem although it is installed on the system. Any idea? ---
**Author:** ![zakifataya](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/z/c89c15/32.png) [@zakifataya](https://www.ruby-forum.com/u/zakifataya)\ **Post date:** [October 19, 2008, 6:10pm UTC](https://www.ruby-forum.com/t/preferred-adapter-for-postgresql-8-3-on-rails-2-0-2/133475/6 "2008-10-19T18:10:13Z")
Holy crap!!! How can I install ruby-pg when PostgreSQL is on another box? The gem won’t build without the --include=/… I want to keep PostgreSQL and my Rails app separated. I am running Debian Etch. Do I compulsory need to install a copy of the package postgresql on my Rails server without actually using it? ---
**Author:** ![zakifataya](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/z/c89c15/32.png) [@zakifataya](https://www.ruby-forum.com/u/zakifataya)\ **Post date:** [October 21, 2008, 5:12am UTC](https://www.ruby-forum.com/t/preferred-adapter-for-postgresql-8-3-on-rails-2-0-2/133475/7 "2008-10-21T05:12:25Z")
Mikel L. wrote: > In this case it is a good idea to install postgresql on your rails > box. Just don’t initialize a database. I’m curious if it would be sufficient to install the development libraries. I haven’t tried that before, so the development libraries might be dependent on the run-time libraries, so you’d have to have it anyway. It’s probably worth looking into, though. Peace. ---
**Author:** ![zakifataya](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/z/c89c15/32.png) [@zakifataya](https://www.ruby-forum.com/u/zakifataya)\ **Post date:** [October 20, 2008, 11:29am UTC](https://www.ruby-forum.com/t/preferred-adapter-for-postgresql-8-3-on-rails-2-0-2/133475/8 "2008-10-20T11:29:06Z")
On Mon, Oct 20, 2008 at 3:10 AM, Fernando P. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Holy crap!!! How can I install ruby-pg when PostgreSQL is on another > box? The gem won’t build without the --include=/… > > I want to keep PostgreSQL and my Rails app separated. I am running > Debian Etch. Do I compulsory need to install a copy of the package > postgresql on my Rails server without actually using it? In this case it is a good idea to install postgresql on your rails box. Just don’t initialize a database. This way you get all the standard posgres tools and are able to use the new ./script/dbconsole. Mikel – > **[Mikel Lindsaar](https://lindsaar.net/)** > > Internet Home for Mikel Lindsaar Rails, RSpec and Life blog… ---
**Author:** ![zakifataya](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/z/c89c15/32.png) [@zakifataya](https://www.ruby-forum.com/u/zakifataya)\ **Post date:** [October 21, 2008, 9:59am UTC](https://www.ruby-forum.com/t/preferred-adapter-for-postgresql-8-3-on-rails-2-0-2/133475/9 "2008-10-21T09:59:21Z")
Hi, yeas it is enough to install the dev libs for postgresql in order to have ruby-pg compile. I remembered that for MySQL you just need to install the dev libs in order to build the fqster mysql gem. My app is now remotely communicating with PostgreSQL thanks to ruby-pg.