Forum: Ruby on Rails Connecting to existing postgreSQL database in Win32

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Toby Corballis (Guest)
on 2006-04-22 17:33
I've been runnning Perl under Apache for a while but have decided to try
using Ruby-on-Rails. My current database is postgreSQL 8.1. I have no
problem connecting to it using Perl or PHP 5. However, I'm obviously
missing something 'cos no matter what I do I cannot connect to the
database from RoR.
I have followed all of the instructions I could find and when I start
irb and type "require 'postgres'" I get the value 'true' echoed back to
me.
My database is called bookkeeping and has several tables, one of which
is called 'address'. I've changed the .yml file to have the following:


development:
  adapter: postgresql
  database: bookkeeping_dev
  username: toby
  password: whatever
  host: localhost
  schema_search_path: public

test:
  adapter: postgresql
  database: bookkeeping_test
  username: toby
  password: whatever
  host: localhost
  schema_search_path: public

production:
  adapter: postgresql
  database: bookkeeping
  username: toby
  password: whatever
  host: localhost
  schema_search_path: public

I've generated the app files by using the following commands:

rails bookkeeping
ruby script/generate model address
ruby script/generate controller address

When I try to start WEBrik I get the following response:

[2006-04-22 14:30:54] INFO  WEBrick 1.3.1
[2006-04-22 14:30:54] INFO  ruby 1.8.2 (2004-12-25) [i386-mswin32]
[2006-04-22 14:30:54] INFO  WEBrick::HTTPServer#start: pid=13984
port=3000
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_
adapters/postgresql_adapter.rb:24: [BUG] Segmentation fault
ruby 1.8.2 (2004-12-25) [i386-mswin32]


This application has requested the Runtime to terminate it in an unusual
way.
Please contact the application's support team for more information.

Can anyone help before I decide that cutting my head off with a plastic
fork is more fun :)

Many thanks
This topic is locked and can not be replied to.