Re: SLOW Remote Connection to PostgreSQL Database

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: Chris <dmagick(at)gmail(dot)com>
Cc: "Matt White" <whiteqt(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: SLOW Remote Connection to PostgreSQL Database
Date: 2007-10-07 19:29:27
Message-ID: dcc563d10710071229o630ace1dm6f62845640bab275@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/4/07, Chris <dmagick(at)gmail(dot)com> wrote:
> Matt White wrote:
> > Hello,
> >
> > I am running a Rails app on server1 that connects to dbserver where
> > the database is. There is another server, server2, that connects to
> > dbserver quickly and returns quickly no matter how high dbserver's
> > load is. Doing "psql -h dbserver.domain.com database username" from
> > server1 times out every time.
>
> My guess is a firewall.
>
> telnet server.domain.com 54332

I believe we've seen this problem as well when reverse lookups were
enabled and misconfigured.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2007-10-07 19:37:48 Re: ERROR: could not open file "pg_subtrans...
Previous Message Pavel Stehule 2007-10-07 18:07:17 Re: Embedding code in Postgres source code