postgresql failed to establish a connection to <pg server name>

From: "Al-Salami, Adel" <saa(at)klinkhammer(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: postgresql failed to establish a connection to <pg server name>
Date: 2012-02-01 12:59:31
Message-ID: A325334B2DF7DC4690FF38CB11BC3AFB2304E812B9@w2k8n202
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear all,

i really have a serious problem with the connection to postgres windows 2008R2 x64 Server,
am using Npgsql .net using VB.NET and trying to make a stress test about the connections ammount, trying to open about 200 sessions from a client Windows7 PC.
Randomly I get an error message in my vb.net from the npgsql saying that "postgresql failed to establish a connection to < pg server name >" that happen for about 10 percent of the connections randomly, meanwhile on the server itself I found errors like:

EOF on Client-Connection
No connection could be made because the target machine actively refused it.

When I try to run my program from postgres server locally then all goes fine with no error at all, only from a remote PC or Server, I HAVE STOPED ALL WINDOWS FIREWAL and ANY FIREWAL SOFTWARE on both Server and client, but still facing the problem.

Please Help

Adel

________________________________
A. Klinkhammer F?rderanlagen Kreative Lager- und Produktionslogistik GmbH
Sitz der Gesellschaft: N?rnberg * Registergericht: Amtsgericht N?rnberg, HRB 15958
Gesch?ftsf?hrer: Frank Klinkhammer, Gerald Schulz
USt ID: DE 198 660 907 * Steuer Nr.: 241/115/83087

Diese E-Mail enth?lt vertrauliche und/oder rechtlich gesch?tzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrt?mlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail sind nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

Browse pgsql-admin by date

  From Date Subject
Next Message brooks.glenn 2012-02-01 23:27:07 overcoming a recursive relationship in a sql statement
Previous Message Walter Hurry 2012-02-01 01:04:58 Re: Is it possible to create a CHECK constraint for my use case?