Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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 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


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.

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group