Looking at the provided logs, it appears that the private-address matches the IP address being refused access.
2014-01-28 01:37:15 INFO worker.uniter.jujuc server.go:102 running hook tool "relation-set" ["hostname=10.5.0.7" "data base=testcatalog"] 2014-01-28 01:37:21 INFO juju.worker.uniter context.go:323 HOOK FATAL: no pg_hba.conf entry for host "10.5.0.7", user "db_18_test_catalog", database "testcatalog", SSL off
I think this discounts IP address mismatch problems I mentioned in comment#2
Looking at the provided logs, it appears that the private-address matches the IP address being refused access.
2014-01-28 01:37:15 INFO worker.uniter.jujuc server.go:102 running hook tool "relation-set" ["hostname= 10.5.0. 7" "data test_catalog" , database "testcatalog", SSL off
base=testcatalog"]
2014-01-28 01:37:21 INFO juju.worker.uniter context.go:323 HOOK FATAL: no pg_hba.conf entry for host "10.5.0.7", user
"db_18_
I think this discounts IP address mismatch problems I mentioned in comment#2