Jerry LeVan <jerry.levan@xxxxxxx> writes: > Something seems to have messed up my dblink interface... > The only thing I can think that has changed the last week > was the installation of 8.3.7. What version were you using beforehand? Are you *sure* nothing else in your environment has changed? > levan=# select dblink_connect('host=mbp user=levan dbname=levan > password=foobar') > levan-# ; > ERROR: could not establish connection > DETAIL: could not translate host name "mbp" to address: Temporary > failure in name resolution ... because it is really, really hard to see how that particular failure could arise from anything except a broken DNS configuration. Try "nslookup mbp" at the shell command prompt. If that fails with a similar error message, Postgres is not at fault. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general