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