Lists: | pgsql-general |
---|
From: | Matt White <whiteqt(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | SLOW Remote Connection to PostgreSQL Database |
Date: | 2007-10-03 15:39:59 |
Message-ID: | 1191425999.460703.36320@g4g2000hsf.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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. The same command from server2 returns
quickly. dbserver is located in a remote location but server1 and
server2 are in the same building using the same internet connection.
Requests directly to server1 return quickly as well. What do I need to
look at to make it move quickly? Thanks!
From: | Chris <dmagick(at)gmail(dot)com> |
---|---|
To: | Matt White <whiteqt(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: SLOW Remote Connection to PostgreSQL Database |
Date: | 2007-10-05 04:11:26 |
Message-ID: | 4705B96E.9070506@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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 5432
and see if that works.
--
Postgresql & php tutorials
http://www.designmagick.com/
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 |
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.