Pensieri di un lunatico minore

Ruby, PostgreSQL and Windows

I have been alternating, back and forth, between my MacBook Pro and a Windows XP notebook for development, depending on where I’m at. This has been relatively easy through the use of Subversion, however, I keep running into a consistent problem when using Rails and PostgreSQL together:

./script/../config/../vendor/rails/railties/lib/commands/runner.rb:47: c:/ruby/lib/ruby/1.8/readbytes.rb:21:in `read': Invalid argument (Errno::EINVAL)
        from c:/ruby/lib/ruby/1.8/readbytes.rb:21:in `readbytes'
        from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/message.rb:32:in `read'
        from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/connection.rb:30:in `initialize'
        from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/connection.rb:29:in `loop'
        from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/connection.rb:29:in `initialize'
        from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/postgres-compat.rb:23:in `new'
        from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/postgres-compat.rb:23:in `initialize'
        from ./script/../config/../vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:24:in `connect'
         ... 14 levels...
        from ./script/../config/../vendor/rails/railties/lib/commands/runner.rb:47
        from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
        from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'
        from script/runner:3

This seems to coincide with another problem I have, which is the PostgreSQL daemon looses contact with things like pgAdmin, so I don’t honestly think it’s Ruby-related, but instead something in my PostgreSQL configuration. I am running 8.1.4 on Windows XP SP2. I’m bonding to localhost to get connected.

Update: Looking through the PostgreSQL logs, I find this:

2006-10-24 23:33:10 LOG:  could not receive data from client: An operation was attempted on something that is not a socket.
2006-10-24 23:33:10 LOG:  incomplete startup packet

It seems to happen, whether I am bound to the loopback or another address.