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

Question

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

score 2 · Accepted Answer · answered Aug 04 '09 at 12:22

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

Reuben Mallaby · Answer 2 · 2009-08-04T08:31:35.950

1

gem to install is ruby-pg

Tutorial for 8.04

Tutorial for 9.04 LAMP with Postgres

edited Aug 04 '09 at 08:31

answered Aug 04 '09 at 08:25

Reuben Mallaby

5,740
4
47
45

Installation is simple - if you only use the local machine for your rails apps you won;t need to change access config. – Reuben Mallaby Aug 04 '09 at 08:29

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

2 Answers2

Linked