Обсуждение: Re: Pgsql remote connection issue was: Regarding PostgreSQL problem.
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).
Scott Marlowe <scott.marlowe@gmail.com> writes: > On Tue, Jun 9, 2009 at 11:57 PM, Hapase, > Pranjali<Pranjali.Hapase.ext@geometricglobal.com> wrote: >> But I am not able to connect to the PostgreSQL which is install on the >> another machine. > You need to edit two files to access pgsql remotely. postgresql.conf > (listen_address) and pg_hba.conf (self documenting and sorta obvious). You may also need to change the platform's firewall configuration to let the connection through; or even poke holes in the firewall rules of intervening routers. It's usually not that hard to diagnose the cause from the specific error message you get. If you get one of the ones shown here http://www.postgresql.org/docs/8.3/static/client-authentication-problems.html then it's a pg_hba.conf configuration problem. If you get "connection refused" then it's either a software firewall problem or listen_address problem. If it just sits and times out after a couple minutes, the packets are probably getting thrown away by some intervening router. regards, tom lane