Postgresql by network

Posted by sev on Super User See other posts from Super User or by sev
Published on 2010-05-08T17:59:41Z Indexed on 2010/05/08 18:00 UTC
Read the original article Hit count: 305

Filed under:
|
|

I have running PostgreSQL sever on 192.168.0.102:5432. postgresql.conf has this line:

listen_addresses = '*'

and pg_hba.conf has this one:

host    all         all         127.0.0.1/32          trust

I have Rails app with same config/database.yml

development:
  adapter: postgresql
  host: 192.168.0.102
  port: 5432
  encoding: unicode
  database: test
  pool: 5
  username: test
  password:

But when I run rake db:migrate I get (I run this from 192.168.0.100)

FATAL:  no pg_hba.conf entry for host "192.168.0.100", user "test", database "postgres", SSL on
FATAL:  no pg_hba.conf entry for host "192.168.0.100", user "test", database "postgres", SSL off
...

Who can help with this?

© Super User or respective owner

Related posts about ubuntu

Related posts about postgresql