• Home
  • Forums
  • FME Form
  • General
  • Update Data in ArcGIS Portal, FATAL: remaining connection slots are reserved for non-replication superuser connections"
Question

Update Data in ArcGIS Portal, FATAL: remaining connection slots are reserved for non-replication superuser connections"

  • 23 November 2021
  • 2 replies
  • 10 views
B
Badge

When I tried to update existing hosted layer in ArcGIS portal, periodically , I got this error message when trying to access the data by ArcGIS portal feature service reader

imageAnyone seen this before or please help me to fix this error?

2 replies

virtualcitymatt
Rank
Userlevel 4
Badge +26

Here's some further reading on this issue - it looks like it could be somethign which can be configured on the backend PostgreSQL database:

https://stackoverflow.com/questions/11847144/heroku-psql-fatal-remaining-connection-slots-are-reserved-for-non-replication

My guess is that there is some limit to the number of connections to the WFS, when too many people or connections are made the database begins to refuse connections.

Are you in control of the WFS?

B
Badge

Here's some further reading on this issue - it looks like it could be somethign which can be configured on the backend PostgreSQL database:

https://stackoverflow.com/questions/11847144/heroku-psql-fatal-remaining-connection-slots-are-reserved-for-non-replication

My guess is that there is some limit to the number of connections to the WFS, when too many people or connections are made the database begins to refuse connections.

Are you in control of the WFS?

Thanks for the answer. Unfortunately, I'm not in control of the WFS. I've asked the admin, he said the default number of max-connections is 150.

Reply


Community Stats

28,631
Posts
109,156
Replies
36,510
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.