Mark Richman provides expert advice, strategy, and software solutions to businesses worldwide. His clients range from the Fortune 500 to small businesses to startups seeking dramatic results. Mark creates and improves business-critical web applications, increasing productivity and maximizing profits.

Archive for the ‘postgresql’ Category

Tools of the Trade

Posted on October 14, 2009, 9:10 AM, by Mark A. Richman, under General, Tools, guitar, postgresql, rails, ruby.

Many of my colleagues in the Ruby on Rails community have been posting a “tools of the trade” blog post, covering their hardware and software preferences. Now that I am nearly Microsoft-free, I figured I’d update my list.
Hardware

Apple Mac Pro 8-core Xeon, 10GB RAM, 320GB + 500GB 7200rpm SATA drives. This is my main box [...]

2 Comments | Read the rest of this entry »

How to install pg (postgresql) gem on Snow Leopard, 64 bit

Posted on October 3, 2009, 10:12 PM, by Mark A. Richman, under postgresql, rails, ruby.

This one was a toughy. I installed PostgreSQL 8.4 from source in /usr/local/pgsql. Install the gem as follows:
sudo -s
export PATH=/usr/local/pgsql/bin:${PATH}
env ARCHFLAGS=”-arch x86_64″ gem install pg

No Comments | Read the rest of this entry »