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

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@hogranch.com>
To: <pgsql-bugs@postgresql.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 ?




--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs