Question 232047 in PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – Remaining conmections slots are reserved for non-replication superuser. Error on azure

I have a .net web api that use postgresql. Backend is deployed on azure. Sometimes this error occures. I have max_connection set to 50, and I think it should be enough. In my code i use Entity Framework Core.

How to handle this problem because I can’t find why and where it throws.

Tags:

2

Answers


  1. 0

    Try to limit number of pooled connections in EF Core. For Npgsql it will be parameter Maximum Pool Size=45 in connection string (default value is 100).
    More info: https://www.npgsql.org/doc/connection-string-parameters.html

    Login or Signup to reply.
  2. 0

    I think you need to check the connections usage for the database and making sure you are closing and disposing of connections properly after use. For you to have detailed process on how to handle that issue you can follow this article here, and also this stackoverflow question which is similar to yours, here

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search