Thread: pg_hba.conf configuration

pg_hba.conf configuration

From
"Paul Wallace"
Date:
Hi,
    Presumably to make a connection to a remote database, I need to start
the postmaster with the -i switch, and configure the pg_hba.conf file? Can
you tell me what needs to be edited in this file please? A single connection
will suffice, ie appserver host to the DB host. Do I add my IP anywhere in
this file? (the file being edited obviously being situated at the DB host!)

Thanks very much

Paul.

Paul Wallace
Concerto Developer/Support Consultant
ProSolutions Asia Pacific Co., Ltd.
Tel +66 2 583 6161-5
Fax +662 583 6535
www.ProSolutions-ap.com



Re: pg_hba.conf configuration

From
Rene Pijlman
Date:
On Wed, 19 Dec 2001 14:22:49 +0700, you wrote:
>and configure the pg_hba.conf file? Can you tell me what needs to
>be edited in this file please?

You need to allow connections through a TCP/IP socket from the
client IP that the JDBC driver is running on. The documentation
in the .conf file and the Admin Guide
(http://www.postgresql.org/idocs/index.php?client-authentication.html)
tell you how to do that.

Regards,
René Pijlman <rene@lab.applinet.nl>