Forum Discussion

arvindyadav's avatar
arvindyadav
Post Partisan
8 years ago

Not able to connect with Postgresql

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

Need Help

2 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    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. :smileyhappy:

     

    Regards