tips for installing postgres for a rails project on a linux box

Question

hi

I want to use a postgres database for 2 rails projects and for some php blogs. Does anybody have tips for me, which pg gem I should install for ruby? I'm searching also for some general postgres config tips.

I run Ubuntu 9.04 as Server.

Maybe a (not outdated) good tutorial would be great :)

thanks guys

Answer 1

gem to install is ruby-pg

Tutorial for 8.04

Tutorial for 9.04 LAMP with Postgres

Answer 2

This article from the Rails wiki should contain the information you are looking for.

I suggest you to install the pg GEM:

gem install pg

Also, Slicehost published a really interesting collection of article about using and configuring PostgreSQL on Ubuntu: http://articles.slicehost.com/postgresql