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