Skip to main content

Ruby on Rails with Postgresql on Debian/Ubuntu

Based on the information scattered here and there, if you want to use postgresql with Ruby on Rails on Debian/Ubuntu, you can use 2 approaches:

The first approach based on various places and experiment is
1. Set adapter of database.yml to postgresql.
2. Install postgresql-server-dev-?.? (?.? = 8.3 in Debian Lenny).
3. Install the pg gem with "gem install pg"
The above approach has been tested.

Another approach based on http://www.williamchu.com/blog/?p=9
1. Set adapter of database.yml to jdbcpostgresql
2. Install the activerecord-jdbcpostgresql-adapter with "gem install activerecord-jdbcpostgresql-adapter jdbc-postgres"
I don't bother to test this approach since it's using jdbc, which means another layer of complexity. But this might be useful if you use JRuby. In addition, this approach should work on other linux distro.
Labels:

Comments

Post a Comment

Popular posts from this blog

The boiling frog: Internet censorship (Fitna) in Indonesia.

Have you heard the story of boiling frog? Taken from wikipedia: "The boiling frog story states that a frog can be boiled alive if the water is heated slowly enough — it is said that if a frog is placed in boiling water, it will jump out, but if it is placed in cold water that is slowly heated, it will never jump out." This blog told me about a decision of a major ISP in Indonesia to censor the controversial fitna film. Regardless of whether that movie deserved to be ban or not, I fear that this censorship is the beginning of boiling frog phenomenon. The justification for the next censorships will be more and more ridiculous that it won't take too long for Indonesia returning to a police state again.. And I do think that the censorship decision is ridiculous. Yes it is probably important to ban this movie in Europe where a majority or people in power are not moslem, because the hatred towards moslem induced by that film put many minority moslems in trouble. But in Ind...
3 comments
Read more

My employees are holding a strike, yay!

Today almost 80% of my employees are holding a strike. The cause was pretty simple, one old employee who had a pretty bad track record was.. verbally disciplined. For whatever reason, he couldn't accept that reprimand so he told his work friends. Now, some of those friends were talented provocators (really. they were pretty good..) . I had awared of them since years ago but they behave well enough so... They coordinate a strike bringing almost 80% of them. The detail is rather sketchy since I wasn't present when the incidence happen. I'll update later. But one thing for sure, I now have a reasonable basis to fire those provocators. Yay! But now I must deal with some future consequences... *sigh*
2 comments
Read more