I’m a newbie at Ruby and Rails, so please forgive me if this is the wrong place to put this up. After spending a day trying to figure out how to set Instiki up with Postgresql, I hope to contribute to everybody’s great effort!
Step 1: Modify the database.yml file in the <instiki_home_dir>/config to use the Postgresql adapter.
| development: adapter: postgresql host: localhost database: instiki_dev username: <your_acct> password: <acct_password> |
Step 2: Modify the database schema file 001_beta1_schema.rb found in <instiki_home_dir>/db/migrate. Remove all the integer datatype’s limit declaration. Postgresql’s integer datatype has no limit.
Change from:| :integer, :limit => 4, |
| :integer, |
Step 3: In the Instiki home directory, run “rake migrate”.
Assumptions:
1. Your Postgresql database server has already been setup.
2. Your database named “instiki_dev” has already been created.
3. Your database user account has already been created.