tag:railsonpostgresql.com,2005:/2009/09/04/rails-postgresql-and-database-drivers Rails on PostgreSQL : Rails, PostgreSQL, and database drivers <h3>If you like Ruby on Rails, you'll love Rails on PostgreSQL!</h3> 2010-07-24T16:27:51+00:00 Typo tag:railsonpostgresql.com,2005:Comment/1 2009-09-04T21:55:37+00:00 2010-07-24T16:27:51+00:00 alex@alexkane.net Comment on Rails, PostgreSQL, and database drivers by alex@alexkane.net

Great website! Is the new pg driver much faster?

 tag:railsonpostgresql.com,2005:Comment/2 2009-09-04T22:27:42+00:00 2010-07-24T16:27:51+00:00 Tom Copeland Comment on Rails, PostgreSQL, and database drivers by Tom Copeland

@alex, Thanks! I haven’t seen any benchmarks… but it’s definitely the way to go.

 tag:railsonpostgresql.com,2005:Comment/8 2009-09-18T10:15:38+00:00 2010-07-24T16:27:51+00:00 Darren Boyd Comment on Rails, PostgreSQL, and database drivers by Darren Boyd

On OSX (Leopard), this is the process I used to get the native gem to build…

sudo su -
export ARCHFLAGS='-arch i386'
export PATH=/opt/local/lib/postgresql83/bin:$PATH
gem install pg
<control + d to log out of super user>

Note that the postgres bin path is specific to my installation.

 tag:railsonpostgresql.com,2005:Comment/9 2009-09-30T10:44:44+00:00 2010-07-24T16:27:51+00:00 Wayne E. Seguin Comment on Rails, PostgreSQL, and database drivers by Wayne E. Seguin

You do not need to install gems as root. If the reason is “because then the command shows up” then add the user’s gem directory to your path:

PATH=$PATH:~/.gem/ruby/1.8/bin

You can even set this exclusively:

GEM_HOME=~/.gem/ruby/1.8

For the purposes of pg gem, in order to cover both bases (both 32 & 64 bit compiled postgres installs) on OSX:

ARCHFLAGS="-arch i386 -arch x86_64"

Ensure that your path has psql in it as noted above. Change /opt/local/lib/postgresql83/bin to wherever you have pg_config located. For me this is:

PATH=$PATH:/usr/local/postgresql/bin ; export PATH

Then install the gem.

gem install pg

This non-root technique is especially useful when you have multiple ruby versions installed and are actively switching/using all of them ( I use rvm for this http://rvm.beginrescueend.com/ )

w00t for Postgres!

 tag:railsonpostgresql.com,2005:Comment/12 2009-09-30T11:46:14+00:00 2010-07-24T16:27:51+00:00 Tom Copeland Comment on Rails, PostgreSQL, and database drivers by Tom Copeland

@wayne, true… I guess that most of the time when I install a gem, though, I want it to be available to all user accounts on the box. But you’re right, another possibility is to just install it to your home directory.