Rails - Feb 2005 - Update to 0.10.0 + Postgresql: "unexpected EOF on client connection"

Hi guys,

I''ve just updated to Rails 0.10.0. I''m running it with
PostgreSQL 8.0.0
on Mac OS X. Since the upgrade my simple Rails app has slowed very
noticeably and I''m getting "unexpected EOF on client
connection"
printed out to my terminal from PostgreSQL. The application still
works however, and eventually generates a correct web page.

I''m thinking that perhaps the connection to the DB isn''t being
closed properly.

Has anybody experienced a similar dramatic drop in performance, and
does anybody know if it''s related my use of PostgreSQL 8.0 ?

Hopefully the cause of the problem is a configuration mistake
that I''ve made, because I''m really excited about using the new
Rails release!

:o)

-- Scott

Hello there,

Problem solved!

In a follow-up two my previous post with the same title,
I''ve switched to using the C-based ruby-postgres-0.7.1 driver with
PostgreSQL 8.0.1 and I''m no longer getting the "unexpected EOF
on client connection" error from PostgeSQL in my terminal.
Previously I was using the Ruby-based postgres-pr-0.3.6.gem.

With regard to speed issues, it turned out that the upgrade had
switched me back to using dispatch.cgi instead of dispatch.fcgi,
in my .htaccess file so it''s no surprise that things got slower!

I realise that this is a common problem and am now a little
embarrassed. Nevertheless, I''m now a happy Rails user once more :o)

I thought I should post an update for other Rails newbies out there.

-- Scott