postgresql failed to establish a connection to - Mailing list pgsql-admin

From Al-Salami, Adel
Subject postgresql failed to establish a connection to
Date
Msg-id A325334B2DF7DC4690FF38CB11BC3AFB2304E812B9@w2k8n202
Whole thread Raw
List 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.

pgsql-admin by date:

Previous
From: Walter Hurry
Date:
Subject: Re: Is it possible to create a CHECK constraint for my use case?
Next
From: brooks.glenn@comcast.net
Date:
Subject: overcoming a recursive relationship in a sql statement