Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 19EE61337B47 for ; Sat, 22 Jan 2011 04:54:01 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 10709-01 for ; Sat, 22 Jan 2011 08:53:53 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtpcorp.com (smtpcorp.com [174.143.60.32]) by mail.postgresql.org (Postfix) with ESMTP id 963D51336B42 for ; Sat, 22 Jan 2011 04:53:53 -0400 (AST) DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=smtpcorp.com; s=main; h=Content-Transfer-Encoding:Content-Type:Mime-Version:References:Message-ID:Date:Subject:From:To; bh=l8zQb6GU+bxNyxNQe2YS4JB4vx+OmXv/y6N+uBPVsbw=; b=TVd0yjyJBhfaaFOn1D9Lsh0Hx0odhLtHTZWShzpryluaU2HB/H6LaHAYlXYQniBmROJtxCO15QZoFBwoXaleUfyY1S5u7/EHPNopZCkH6p9tbccvHyITgM7iIcK9HMmW; Received: from ip-118-90-133-118.xdsl.xnet.co.nz ([118.90.133.118] helo=gonzo) by smtpcorp.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.70) id 1PgZEI-0001jS-8w; mid 144 for pgsql-sql@postgresql.org; Sat, 22 Jan 2011 08:53:54 +0000 Received: from news by gonzo with local (Exim 4.72) (envelope-from ) id 1PgZE4-0004iO-Vl for pgsql-sql@postgresql.org; Sat, 22 Jan 2011 21:53:41 +1300 To: pgsql-sql@postgresql.org Path: not-for-mail From: Jasen Betts Newsgroups: gmane.comp.db.postgresql.sql Subject: Re: Issue with postgres connectivity Date: 22 Jan 2011 08:53:40 GMT Organization: Dis (not Dat) Organisation Lines: 11 Message-ID: References: <2C43C4BE6357654AB4E898C9E9EBA83E32BC2849@mbx.in.v2solutions.com> <20110121105728.GJ80182@spoetnik.xs4all.nl> <2C43C4BE6357654AB4E898C9E9EBA83E32BC287B@mbx.in.v2solutions.com> NNTP-Posting-Host: localhost Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: reversiblemaps.ath.cx 1295686420 18083 127.0.0.1 (22 Jan 2011 08:53:40 GMT) X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a +M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W; (T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6 {T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q; 8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^ User-Agent: slrn/pre1.0.0-18 (Linux) X-Smtpcorp-Track: 21154670.1.13452079 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201101/61 X-Sequence-Number: 35008 On 2011-01-21, Arindam Hore 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