X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3F851DB5FC for ; Mon, 14 Nov 2005 12:58:29 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47770-06 for ; Mon, 14 Nov 2005 16:58:28 +0000 (GMT) X-Greylist: delayed 03:02:19.50356 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 73A7AD9BAD for ; Mon, 14 Nov 2005 12:58:27 -0400 (AST) Received: from blr.corpus.com (unknown [203.200.203.202]) by svr2.postgresql.org (Postfix) with ESMTP id 3E99BF0D90 for ; Mon, 14 Nov 2005 13:56:13 +0000 (GMT) Received: from CORP17 (203.200.203.241.ill-bgl.static.vsnl.net.in [203.200.203.241] (may be forged)) by blr.corpus.com (8.12.8/8.12.8) with SMTP id jAEDnrhj009292 for ; Mon, 14 Nov 2005 19:20:13 +0530 Message-ID: <024701c5e925$67551c60$f1cbc8cb@blr.corpus.com> From: "bhaskar" To: Subject: Socket error - Could not connect to PostgreSQL server Date: Mon, 14 Nov 2005 19:41:29 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_023B_01C5E953.689D64F0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200511/152 X-Sequence-Number: 19525 This is a multi-part message in MIME format. ------=_NextPart_000_023B_01C5E953.689D64F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I have installed PostgreSQL 7.4.8 in Linux machine. I have tried = to connect my PostgreSql Database using a client application (SQL Server = 2000 - DTS). I have done the followings: 1.Used psqlODBC for ODBC provider 2. In pg_hba.config i have added my machines IP address. 3. In postgresql.conf file changed tcpip_socket=3Dtrue. Still I am getting the error like 'Could not Connect to Server; Could = not Connect to remote socket'. Please help me!! Thanks in Advance Bhaskar ------=_NextPart_000_023B_01C5E953.689D64F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
    =    =20 I have installed PostgreSQL 7.4.8 in Linux machine. I have tried to = connect my=20 PostgreSql Database using a client application (SQL Server 2000 - DTS). = I have=20 done the followings:
 
1.Used psqlODBC for = ODBC=20 provider
2. In pg_hba.config i have added my machines IP=20 address.
3. In postgresql.conf file = changed=20 tcpip_socket=3Dtrue.
 
Still I am getting the = error like=20 'Could not Connect to Server; Could not Connect to remote=20 socket'.
 
Please help = me!!
 
Thanks in = Advance
Bhaskar
------=_NextPart_000_023B_01C5E953.689D64F0--