Re: Pgsql remote connection issue was: Regarding PostgreSQL problem. - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Pgsql remote connection issue was: Regarding PostgreSQL problem.
Date
Msg-id dcc563d10906151325t55c0b45cga7803b7e138087e9@mail.gmail.com
Whole thread Raw
Responses Re: Pgsql remote connection issue was: Regarding PostgreSQL problem.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Tue, Jun 9, 2009 at 11:57 PM, Hapase,
Pranjali<Pranjali.Hapase.ext@geometricglobal.com> wrote:
> Hello,
>
>
>
> I am using iReport tool for creating JasperReport & I use backend as
> PostgreSQL.
>
> But I am not able to connect to the PostgreSQL which is install on the
> another machine.
>
> Try to give me a solution.

You might want a more descriptive title next time, you'll get more bites.

You need to edit two files to access pgsql remotely.  postgresql.conf
(listen_address) and pg_hba.conf (self documenting and sorta obvious).

pgsql-admin by date:

Previous
From: Igor Polishchuk
Date:
Subject: Is IDLE session really idle?
Next
From: Anj Adu
Date:
Subject: Re: partition insert performance