Re: Issue with postgres connectivity

What I have seen is that, when I am trying to connect the db server from application server using ssh, the response was very slow. While from db server to application server it is very quick as usually.

-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org [mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Jasen Betts
Sent: Saturday, January 22, 2011 2:24 PM
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Issue with postgres connectivity

On 2011-01-21, Arindam Hore <arindam(dot)hore(at)in(dot)v2solutions(dot)com> wrote:
> We are accessing database using ip address.

try adding the IP addresses of some of the clients as seen by the
server to /etc/hosts on the server. see if that helps.

try connecting to the server locally using 'su postgres -c psql'
see if that's slow too.

--
⚂⚃ 100% natural

--
Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.