[Rails] a remote database issue

Jeremy Kemper jeremy at bitsweat.net
Mon Feb 28 22:32:52 GMT 2005


Robby Russell wrote:
> I am trying to connect to a remote postgresql database and am having no
> luck when I run rake.
>
> Why is it trying to use the sockets when I need it to connect remotely?
> It almost seems like it is ignoring the host: 

Indeed!  Take a look at the tasks in the Rakefile.  If the database
config specifies a host, the command-line invocations of psql, createdb,
etc should include the -h option.  This would be a quick patch; give it
a shot :)

For the truly obtuse among us, run pgpool on a local domain socket
pointing to the remote PostgreSQL database.

jeremy


More information about the Rails mailing list