Re: BUG #5994: Can't excute DBI->connect to oracle by client site

Perhaps you misunderstanding what I mean.
I can connect to postgreSQL server correctly,
but When I connect postgreSQL with TCP Sockets, it return error to connect to oracle server by DBI->connect from perlu script.

When I connect postgreSQL with Unix Domain Sockets,it works well.

My conf file:
listen_addresses = '*' # what IP address(es) to listen on;
host all all 0.0.0.0/0 password

----- Original Message -----
From: "John R Pierce" <pierce(at)hogranch(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Sent: Wednesday, May 11, 2011 11:40 AM
Subject: Re: [BUGS] BUG #5994: Can't excute DBI->connect to oracle by client site

On 05/10/11 8:09 PM, 李紅兵 wrote:
> I run my test program with 2 ways in the same login environment.One succeed and one fail.
>
> 1) psql -d dbi_link_test
> -->connect succeed
> 2) psql -h HOSTNAME -d dbi_link_test
> -->connect fail
>
> The different is connection options(Unix Domain Sockets/TCP Sockets).

is your server listen_addresses = '*' ? if not, its not listening on the
interface that will respond to connections to 'HOSTNAME'

and, is pg_hba.conf configured for an appropriate authentication method
for `host` connections ?