Not able to connect with Postgresql

[arvindyadav]

Hi Team,

I am getting an error like

Details: "An error happened while reading data from the provider: 'No connection could be made because the target machine actively refused it'"

While I have Installed Npgsql 3.2.6 version and also added AWS certificate in console.msc

Then Why I am getting this error again and again.

Regards,

Arvind

[Bhavana_k]

hey @arvindyadav  did you get any solution on this error? I'm receiving same error. Thanks.

[v-ljerr-msft]

Hi @arvindyadav,

According to the error message, it seems to be a connection configure issue on your Postgresql server. 

Here is similar thread on SO, in which some solutions are mentioned. Could you go to check if it helps in your scenario?

Solutions from around the web and other SO answers suggest:

• Disable TCP autotuning and tweak the TCP/IP registry keys on the server, e.g. set TcpAckFrequency - see this article for details
• Make TCP setting adjustments (like WinsockListenBacklog) - which may be affected by whether connection pooling is in use or not - see this MS support article, which is for SQL Server 2005 but has some great tips on troubleshooting rejected TCP/IP connections (using Network Monitor, but applies to newer tools)
• Faster request processing if you have enough control of the server - source
• Disabling network proxying (in your load testing app): <defaultProxy> <proxy usesystemdefault="False"/> </defaultProxy> - source

---

In addition, if the issue persists, I would suggest that you also post it on the Postgresql Forum for better assistance on this issue. 

Regards