[Rails] a remote database issue

Robby Russell robby at planetargon.com
Mon Feb 28 22:10:38 GMT 2005


I am trying to connect to a remote postgresql database and am having no
luck when I run rake.

For example:

 rake outputs:

>pg_dump: [archiver (db)] connection to database "dbname" failed: could
>not connect to server: No such file or directory
>        Is the server running locally and accepting
>        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>dropdb: could not connect to database template1: could not connect to
>server: No such file or directory
>        Is the server running locally and accepting
>        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>createdb: could not connect to database template1: could not connect to
>server: No such file or directory
>        Is the server running locally and accepting
>        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>psql: could not connect to server: No such file or directory
>        Is the server running locally and accepting
>        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

my database.ymp looks like this:

>development:
>  adapter: postgresql
>  database: dbname
>  host: 192.168.1.25
>  port: 5432
>  username: webuser
>  password: password

Why is it trying to use the sockets when I need it to connect remotely?
It almost seems like it is ignoring the host: 

Any thoughts?

-Robby

-- 
/***************************************
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON  | www.planetargon.com
* Portland, OR  | robby at planetargon.com
* 503.351.4730  | blog.planetargon.com
* PHP/PostgreSQL Hosting & Development
* --- Now hosting Ruby on Rails Apps ---
****************************************/



More information about the Rails mailing list