Ruby Forum Ruby on Rails > Rails + Postgres + Solaris = ?

Posted by Hunter Hillegas (Guest)
on 08.05.2008 04:37
(Received via mailing list)
Hello All,

I'm trying to move an application from Linux to OpenSolaris (Joyent).

Our Rails 2.0.2 app uses PostgreSQL 8 for its main database.

It seems there's a known bug w/ Postgres and Solaris that requires the
connections to go through 'localhost' instead of using the traditional
(socket?) connection method.

My database works great with the command line Postgres tools (psql) as
long as I use the 'psql -h localhost' setup.

Well, it's not working well with Rails.

I have a database.yml that looks like this:

production:
   adapter: postgresql
   database: city2_production
   host: localhost
   port: 5432
   encoding: latin1
   username: user
   password: pass

But, when Rails attempts to hit the DB, I see this in the log:

PGError (server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.
):

I've also tried 127.0.0.1 w/o luck.

Anyone run into this? Know the solution? Joyent recommended I come
here after their forums didn't help.

I would very much appreciate a point in the right direction.

Thanks,
Hunter