search

pwtail / vinyl_v1

2 stars 1 forks source link

Pool Connection Failed #5

Closed dejmail closed 2 years ago

dejmail commented 2 years ago

Hi there. I've finally gotten my scraping script to work, but the problem now is that I am getting the following errors.

WARNING | 2022-09-05 20:21:00 | MainThread | psycopg.pool._add_connection.422 | error connecting in 'pool-24': connection failed: FATAL: remaining connection slots are reserved for non-replication superuser connections

Obviously I have too many connections, and the previous connections that had been negotiated with the server are not being properly reused if that is even supposed to happen.

Any ideas ? Is it just a matter of optimising the postgres settings ?

Thanks

dejmail commented 2 years ago

Could be connected to #7

dejmail commented 2 years ago

It seems this is more to do with Django creating persistent connections. Not related to this package. I will try pgbouncer or something else.